If I put this formula into a cell:
=SEARCH("I","Team")
...it would return a "#VALUE" error. When I put this line into code:
...I'm not surprised that it gives an error message too. But if I try to trap the error with:Please Login or Register to view this content.
...I still get an error message. Apparently VBA is so picky about that error, it won't even let IsError process it.Please Login or Register to view this content.
The same thing happens with the Match function, and probably others that can give errors.
Is there any way around this?
Bookmarks