View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
crimsonkng crimsonkng is offline
external usenet poster
 
Posts: 42
Default begins with, not equals, using activecell.value

What's the VB command, in an Excel macro, to determine if a cell begins with
certain words?

Quite frequently, I use the command: If ActiveCell.Value = "Specific Words"
Then etc.

But now I want to search for a cell that begins with the words "Up to ..."
But the rest of the sentence can be 150 different things so it's not
practical for me to search for every combination of words.

So, how do I say "if the cell begins with the words 'Up to' Then ...?

I searched on the web and in Excel "help" and became thoroughly confused.
Thanks, in advance.

Dan