I need to check if there are occurrences of a word in column A. I use this simple code:
It works all right bcs FIND returns ‘Error’ when there are no occurrences or no more.Please Login or Register to view this content.
The trouble is that it will go on beyond the specified range of column A and find occurrences anywhere in the worksheet, which I don't want. How can I restrict the search to the specified range only?
(I know there are other functions like For… Next… with Set…, etc. But FIND is more economical in terms of code lines and I want to keep it short bcs my macro is already very long).
Bookmarks