If you don't want a formula in column C and you want ALL of column C filled
then:

Sub demo()
For i = 1 To 65536
Cells(i, 3) = Cells(i, 1) + Cells(i, 2)
Next
End Sub

--
Gary's Student


"Sam" wrote:

I am wondering if there is a macro that will add column "A" and column
"B" then post final output to column "C"

I have seen some formulas that work but they are very specific like:
=SUM(A8,B8)C8
I need to be able to calculate "All of A + B columns" not just A8
Also some times colums "B" will be empty

Thanks in advance
Jenny the Excell Newbee