Look in vba help for using functions in macros or just use the FIND method
in vba instead. Also in HELP.

--
Don Guillett
SalesAid Software

"tam" wrote in message
...
cells(1, 1).Formula = "=Search("":"",Sheet2!cells(1,1),1)"
What is wrong with this formula? How do I use this type of cell reference
in a formula?