What's the vba equivalent of search(text1,string,1)?
 

I tried to use the search function in vba, something like the
following:

position = search(text1, string,1)

and got and error.

How is this done in a macro? Thanks.

What's the vba equivalent of search(text1,string,1)?
 

maybe instr

InStr([start, ]string1, string2[, compare])

--


Gary


"John Smith" wrote in message
...
I tried to use the search function in vba, something like the
following:

position = search(text1, string,1)

and got and error.

How is this done in a macro? Thanks.