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

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

Any help would be greatly appreciated.

Thanks,
Pete

--
PGalla0
-----------------------------------------------------------------------
PGalla06's Profile: http://www.excelforum.com/member.php...fo&userid=2426
View this thread: http://www.excelforum.com/showthread.php?threadid=39860