HI

where you have Double Quote marks in your formula just use
"" Instead of "

so your example would become

Range("A1").Formula = "=SEARCH("" "",B1,1)"


HTH

Davi

--
Message posted from http://www.ExcelForum.com