View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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.