"If" Formula in VBA
Try doubling your double quotes within the string. VBA does not like
double quotes inside a string and the workaround is to use two double
quotes wherever there was one.
Range("B20").formula = "=IF('Sign 2'!P650,'Sign 2'!E10,"""")"
Post back if you still get an error.
|