Peter,

Range("V2").Formula = "=IF(Q20,""Indemnity"",""Medical"")"

HTH,
Bernie
MS Excel MVP


"PGalla06" wrote in message
...

I'm trying to write an if statement using VBA that returns text, however
I can't seem to figure out how to get it to work as I need to include
apostrophes in the if statement. Below is the code that I'm working
with:

Range("V2").Formula = "=IF(" & "Q2" & "0," & "Indemnity" & "," &
"Medical" & ")"

Any help would be greatly appreciated.

Thanks,
Peter


--
PGalla06
------------------------------------------------------------------------
PGalla06's Profile: http://www.excelforum.com/member.php...o&userid=24260
View this thread: http://www.excelforum.com/showthread...hreadid=398605