Need to Search from Bottom to Top

I have a UserForm that searches through data starting at A1 and going down. A separate UserForm is what pastes the data starting with A1 and going down. Ive found that when my user submits bad data, they just re-submit new data. The problem is that when the code below searches through the data, it finds the bad data first. Is there a way to change this code so it searches starting with A60000 and goes up?

Here is my code

Please Login or Register  to view this content.

You can build you own find function!

Originally Posted by raypayette

You can build you own find function!

I didnt mean my code as in I wrote it all myself. Most of the code in my sheets are adapted from questions I ask on this forum.

Perhaps a few keywords to get me headed in the right direction.

I suggest that this is a good time to learn VBA, so perhaps you could buy a book on it such as Microsoft's Excel 2003 Step by Step.

So what I asked about search from bottom to top is possible?

Yes if you build your own function!

I will figure it out then and share my results

Thank you. Im afraid I may be headed to a Black List for asking too many questions. Perhaps I should spend more time in the New Users Forum helping with the easy questions.

I dont want to upset anyone, and usually I try to ask basic questions but I added the code this time because most people seem to want to know exactly what Im doing and what I have to work with.

If anyone thinks I take take take, and never give, Excel is something I am learning and I am active on about 10 other forums some where I am the expert, and I dont mind sharing what I know there. I understand the frustration if someone gave me a good answer and I asked them to detail how every line works. Of course, some answers I have received came with detailed instructions on what every line does, which is fine with me.