Using wildcards with the "Like" command
 

Help !

I want to check values in a column to see if the match a
certain value. I want to use a wildcard to save lines but
I am not sure how the "like" command works.

Can anybody help ?

Cheers and thanks

Tim

Using wildcards with the "Like" command
 

Tim,

Try something like

If Range("A1").Value Like "ABC*" Then

This will match any string beginning with the letters "ABC".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Tim Patton" wrote in message
...
Help !

I want to check values in a column to see if the match a
certain value. I want to use a wildcard to save lines but
I am not sure how the "like" command works.

Can anybody help ?

Cheers and thanks

Tim