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

  • Thread starter Thread starter Kobayashi
  • Start date Start date
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?
 
Back
Top