View Single Post
  #1   Report Post  
tam
 
Posts: n/a
Default using search function in macro

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?