how to detect whether VBA excel found something? -
I am using it in macros to find stuff in my sheet:
Selection (Address: = Email, After: = Activewel, Lookin: = XLFarmula, Lookout _: = XlPert, Searchorder: = XLBIRIO, Search Direction: = XLX, Matchcases: = _ False, Search Format: = False). Activate
How can I tell if something has been found or not?
range as range set = Range = Selection.Find (what: = email, after : = Activist, Lookin: = XLFormula, _ Look at: = XLPirt, Searchorder: = XLBIRIO, Search Direction: = XLX, Matchciss: = _ False, Search Format: = false) If there is no RPG then there is nothing 'when RNG & Lt; & Gt; Nothing is found in some 'RNG' Activate and IF
Comments
Post a Comment