Try this:

Range("A1").Formula = "=Search("":"",Sheet2!cells(1,1),1)"



"tam" wrote:

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?