Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
VBA Code for "" empty cell
1 view
Skip to first unread message
ManhattanRebel
Nov 11, 2009, 8:52:02 PM11/11/09
to
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.
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?
Jacob Skaria
Nov 11, 2009, 8:58:02 PM11/11/09
to
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
---------------
Jacob Skaria
ManhattanRebel
Nov 11, 2009, 9:12:01 PM11/11/09
to
Thank you...that solved the problem
0 new messages