Hi Rene,

Something like this:

Sub test()
ActiveSheet.Range("C1").Formula = "=A1+B1"
ActiveSheet.Range("C1:C50000").FillDown
End Sub


--
Hope that helps.

Vergel Adriano


"Rene" wrote:

Would you happen to know a way that I can copy or paste a sequential formula
down an Excel column without dragging for literally 50 thousand rows.
For example:

=(A1+B1)
=(A2+B2)
=(A3+B3)
=(A4+B4)
=(A5+B5)
=(A6+B6)
=(A7+B7)

--
Rene - Do appreciate your help