IF Formula in VBA code

[Pumper]

Hi All,

I am trying to add this formula =IF(A3<>"",D3-C3,"") into my VBA code without luck

The goal is if cell A3 down to the bottom of the list is not blank then for that row D-C otherwise leave blank.

Have tried various ranges but clearly doing something wrong.

Any advice would be much appreciated!

 

[Michael M]

What column is the formula to go in ??

 

[Michael M]

I have to leave in the next couple of minutes, so this assumes you are putting the formula in Column "E"

Range("E3:E" & Cells(Rows.Count, "A").End(xlUp).Row).Formula = "=IF(A3<>"""",D3-C3,"""")"

 

[Pumper]

@ Michael M, perfect thank you so much!

 

[Michael M]

Glad to help...