Search for string in several cells
Posted on 2012-04-07
I would like to run a macro that performs the following task.
On the active worksheet, search for the string 'Drop' in cells B3, G3, I3, J3. The string 'Drop' is just part of the cell entry.
The string has to be found in all of these cells, i.e. in total 4 instances of this string have to be found in these specific cells , if not (say only B3, G3 and J3 contain this string), a msgbox has to say so and the macro is to exit.
Help is much appreciated.
Thank you very much in advance.