VBA Code for "" empty cell

M

ManhattanRebel

The following IF function works in Excel, but when I copy it into VBA so I
can excute it in a range it will not work.

Range("p6:p40").Formula = "=IF(C6="","",(P5+O6)-M6)"

I think VBA has a problem with "" meaning an empty cell.

Can someone tell me what I can substitute for "" so my formula will work in
VBA?
 
J

Jacob Skaria

Try the below.. VBA recognizes double double quote as a single double quote

Range("p6:p40").Formula = "=IF(C6="""","""",(P5+O6)-M6)"

If this post helps click Yes
 
M

ManhattanRebel

Thank you...that solved the problem

Jacob Skaria said:
Try the below.. VBA recognizes double double quote as a single double quote

Range("p6:p40").Formula = "=IF(C6="""","""",(P5+O6)-M6)"

If this post helps click Yes
Click to expand...
 
Top