how to use * wildcard in .find

[stuck]

I'd like to tweak an exact match .find:

Code: Select all

Set rngFound = Range("A2:AAA2").Find(myVariable)

to work with an asterisk wild card. A search suggested all I needed was:

Code: Select all

Set rngFound = Range("A2:AAA2").Find(what:=myVariable*)

but that gives 'syntax error'

What is the correct syntax?

Thanks,

Ken

[HansV]

Use

What:=myVariable&"*"

[stuck]

That worked after I added spaces:

Code: Select all

What:=myVariable & "*"

Ken
PS my POP solution was to add a line after myVariable was first set:

Code: Select all

myVariable = myVariable & "*"