Hi

"=if(" & Cells(2).Address & "=B,"""",""Match"")"

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Tony Di Stasi" skrev i melding
...
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"" & ")"