Any use:
Sub Macro1()
Range("G1").Select
ActiveCell.FormulaR1C1 = "=RC[-2]+RC[-1]"
Selection.AutoFill Destination:=Range("G1:G26")
End Sub
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Hru48" wrote in
message ...
Hey all,
Is there a way that I can put the formula of SUM(E:F) through the whole
of column G (result field) automatically.
eg so cell G1 would be SUM(E1:F1)
G2 would be SUM(G2:F2)
etc.
many thanks
Hayley
--
Hru48
------------------------------------------------------------------------
Hru48's Profile:
http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=498373