Dear Experts:
I would like to perform the following action on the currently active worksheet using a VBA Macro.
Search for the first occurrence of a number with the following make-up (09-004-95-07, ie. ##-###-##-##)
- lookat: xlWhole
- SearchOrder:xlbyColumns
If the search termi is found, say in Column B, everything in this column is to be selected from B2 to the Last Filled Cell in Column B (Column B is just an example it could also be Column D or any other column letter).
If no such number ( ##-###-##-##, e.g. 09-004-95-07 ) is found, the macro is to say so via a msgbox and will exit the sub.
Help is very much appreciated. Thank you very much in advance.
Regards, Andreas