Avatar of Andreas Hermle
Andreas Hermle
Flag for Germany

asked on 

Search for a certain number and select cells using VBA

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
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Andreas Hermle

8/22/2022 - Mon