Using wildcards with the "Like" command

  • Thread starter Thread starter Tim Patton
  • Start date Start date
T

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
 
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 (e-mail address removed)
 
Back
Top