Multiple Wildcard choices

[boomboomblock]

I have this code that searches for a wildcard. I know from a previous post that you can simply choose 'Ctrl+F' to find and replace words with wildcards. However I need this macro to loop and search for say, 5 wildcards and end whenever it gets to the last wildcard.

Please Login or Register  to view this content.

[AB33]

Are you trying to loop through column B and set 5 different conditions using *?

[boomboomblock]

Yeah all the words that need to be replaced are in column B. There will be other conditions, it will consist of 'B*mena' being one of the wildcards and most of them following the same kind of way.

[AB33]

There are many ways of doing it. Select case is a bit neater.

Please Login or Register  to view this content.

[boomboomblock]

Thanks that's great, easier to do than I thought!