VBA Wildcard character / find cell which CONTAINS a text

**adgjqetuo** · 06-11-2009, 10:30 PM

I need my VB code to find cells that CONTAIN specific text, not have to be = to it. All the cells have a 4 digit code and a space before the word total.

Please Login or Register  to view this content.

I've tried:

Please Login or Register  to view this content.

^ It doesn't error out, but doesn't work either

I've tried to search this but can't seem to find a logical answer.

**pike** · 06-11-2009, 11:10 PM

Hi adgjqetuo

try.....

Please Login or Register  to view this content.

**bigmack** · 06-11-2009, 11:40 PM

You could also use the instr function, assume data is specified as: <4 digits> <space> Total

Please Login or Register  to view this content.

**adgjqetuo** · 06-12-2009, 12:26 AM

Thanks for the reply!

I actually played around some and I got this to work:

Please Login or Register  to view this content.

I was missing the word "LIKE"

**pike** · 06-12-2009, 01:22 AM

hey adgjqetuo
Its allways the simple solution thats best.well done
can you also please mark the post Solved?

**Phil_V** · 06-12-2009, 04:18 AM

Personally I would be tempted to modify the line of code to be:

Please Login or Register  to view this content.

As this will match EXACTLY what you are looking for; 4 digits, a space, "Total".

Using your code the way it is you would also get matches for "SubTotal", and "TeeTotal" for instance.