Hi,

Having problem getting text into formula:

Need to have the following formula in cell(1):

=if(b1="B", "", "Match")

The following code does not work:

Cells(1).formula= "=if(" & Cells(2).address & "=" & ""B""
& "," & """" & "," & ""Match"" & ")"