I've got a macro that searches a column for a particular value. Below is an excerpt of the code
The code works...sort of. On sheet ws, I have an alphabetized list of names. The macro goes through that list, row by row, and compares it to a list on sheet ge (which is also alphabetized).
The problem is that I have two nonconsecutive names in ws that do appear in the ge list. However, the macro only spits out the first match, but not the second. I've confirmed that if I use MATCH() in a cell, both names return a positive result. I'm guessing its something in the way I'm calling Find, but I'm not sure where I'm going wrong.
Thanks for looking!
Please Login or Register to view this content.
Bookmarks