Hi

I need to add a formula to a cell ( actually a range of cells) uing VB.

The formula is

=IF($U6="","",IF(OR($T6="Yes",$U6="Yes"),"HICA",IF($E6="No Notice","CALL","Notice")))

I would like to use something like:

Range("V2").Formula = "=IF(OR(T2="Yes",U2="Yes"),"HICA",IF(E2="No Notice","CALL","Notice"))"


My problem is that the quotes in the formula are read as the end of the string in the vb. Could anyone help please?

Thanks