Hi all,
I am having issues with Find. I have the following code
Debug.Print WsMth.Cells.Find(what:=SelStrg, After:=WsMth.Cells(7, 4), LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, MatchByte:=True, SearchFormat:=False).Address
For some reason, this does not always find the exact SelStrg and I don't know why. I don't know if I should upload my workbook for this one but if you think I should then let me know. In stating this, I thought that xlWhole was used to find an exact match but it is failing me. Any suggestions?
Regards:
Bookmarks