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?
 
ActiveCell.Value Like "Hand*" And Not ActiveCell.Value Like "Hand*lch*"
 
You must log in or register to reply here.

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
Add Trim Function to Code 4
Remove Leading Comma 10
SaveAs call changes text to ##### 4
For Each minor problem 7
Eliminating commas if they are first characters in a string 11
right hand mouse click options 2
Evaluate Method Returns Type Mismatch 9

Back
Top