VBA .FormulaR1C1 nested quotes

[Barkingdoggy]

This code doesn't work because of the nested quotes. I want the code to set the cell formula. The formula should set the cell value to blank if the client data is zero.

ActiveCell.FormulaR1C1 = "=IF('Client Data'!R[-4]C[20]=0,"",'Client Data'!R[-4]C[20])"

What's the right code? TIA

 

[Norie]

Just double them up ""''.

 

[Barkingdoggy]

Yup, thanks!!