How would I c hange this so that it searches the entire spreadsheet every time? because After:=ActiveCell doesn't quite do it.
The only thing I can think of right now is to make cell A1 the active cell after each search. Anyone have any other suggestions?
Cells.Find(What:=SearchData(i), After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate
Bookmarks