Forum Discussion
Solved
VBA to add IF Statement
Good morning all, Having a hard time getting VBA to set a formula into a cell when I use the reset button to delete all contents. Currently I am using: Sub AddFormula() Range("P4").Value = "IF(...
Try this:
Sub AddFormula() Range("P4").Formula= "=IF(D4<>"""",D4,"""")" End Sub
Try this:
Sub AddFormula()
Range("P4").Formula= "=IF(D4<>"""",D4,"""")"
End Sub
Perfect this worked!! I was so close yet so far! Appreciate the quick reply have a good weekend