Here is my problem. I have data in columns A:C however the number of rows
will differ each time.

I need a macro that will paste a preset formula eg. (=sum(A1:C1)) into cell
D1 and drag it down to the last cell which contains data in the previous
columns?

Thanks in advance