I'm using the find function like below but when searching for something that does not exist a message comes up with [run-time error '91'].
Now I could use 'on error resume next' but I'm hoping there is another way.
Can anyone help me out?
Now I could use 'on error resume next' but I'm hoping there is another way.
Can anyone help me out?
Code:
iFindA1 = Worksheets(1).UsedRange.Find("xx").Address