If Cell.Value Like "Hand*" And Cell.Value <> "Hand*lch*" Then???

K

Kobayashi

I'm sure this is very simple? However, I'm very keen but, clearly, still
learning!

What is wrong with this statement? Actually, I'll qualify that because
I know what's wrong with it; it doesn't work! Any ideas why? I know
it's got something to do with my using the wild character * which
negates the second expression but don't know how else to achieve this?

If Cell.Value Like "Hand*" And Cell.Value <> "Hand*lch*" Then

Basically, I have this statement in a For... statement checking all the
cells in a range. However, I want all cells that begin with "Hand" to
be selected APART from those that begin with "Hand" but also have "lch"
afterwards, such as "Hand LCH".

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Then Code Question 7
right hand mouse click options 2
Problems with count, counta and countifs 6
concatenate entries from a column into a cell by logical AND withanother column 2
Automatic GETPIVOTDATA formula generation from within VBA? 0
Calling Specific sheet in workbook with Code 2
Pivot Table to count values 6
Special characters in a string variable 1

Top