Using wildcards with the "Like" command

[Tim Patton]

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

 

[Chip Pearson]

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 [email protected]