Thread
:
Using wildcards with the "Like" command
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
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
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson