Dim rng as Range
set rng = Intersect(ActiveSheet.UsedRange,Columns(1))
rng.offset(0,4).Formula = "=if(A1="""",C1+D1,"""")"

--
Regards,
Tom Ogilvy


"Steve" wrote in message
...
Hi

I would like to populate column E with a formula (column C
+ column D) where the the value of Column A is null.

Is this possible ?

Thank you in advance
Steve