Find Left$

K

kirkm

Hi,

I'm changing some existing code which reads

Set rngFound = .Find(What:=theString, after:=.Range("A1"),
LookIn:=xlValues, LookAt:=xlPart, searchorder:=xlByColumns,
searchdirection:=xlNext, MatchCase:=False, matchbyte:=False)

This finds *theString* but what I want it to look at are the
first 2 characters only e.g. "40*" and select only those. ( The
asterisk doesn't work as in an Access query, either)

Is this possible, or is a completely different method needed?
Thanks - Kirk
 
K

kirkm

.Find(What:= LEFT$( theString ,2)

Yes, although that finds every instance of the two characters, not
just cells that start with them. I could filter and fix the result
somehow but maybe there is another way?

Thanks - Kirk
 

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

Top