"If" Formula in VBA
Put this instead.
Range("B20) = "=IF('Sign 2'!P650,'Sign 2'!E10,"")"
Ryan
"Shane Wierenga" wrote:
I am attempting to add a formula to a cell when a sheet is added to my
workbook. I get the following error when I run the program
"Application-defined or object-defined error". Here is the line of
code that is throwing up the error.
Range("B20").formula = "=IF('Sign 2'!P650,'Sign 2'!E10,"")"
I believe it has to do with the if in the formula but I am unable find
any thine on the subject.
Other formulas such as the formula below are added with no problems.
Range("L20").formula = "=('Sign 1'!P65+'Sign 1'!P70)/'Sign 1'!E10"
Please help if you can.
|