Using null in VBA Formula

[londolozi]

I am trying to use a null in a formula created by a macro

Form4 = "=IF(RC[-1]>0,RC[-1]*RC[-4],"")"

The problem being the last few characters of the code where I want to use ""
The formula cuts off after the last comma and I get

 Form4 = "=IF(RC[-1]>0,RC[-1]*RC[-4],"

How do I insert a null into a formula using VBA without VBA seeing it as end of string?

Thanks in advance

 

[Smitty]

You can use double quotes:

Form4 = "=IF(RC[-1]>0,RC[-1]*RC[-4],"""")"

HTH,