Insert a formula down 50,000 rows

[Rene]

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)

 

[Vergel Adriano]

Hi Rene,

Something like this:

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

 

[Peter T]

or even -

ActiveSheet.Range("C1:C50000").Formula = "=A1+B1"

Regards,
Peter T

 

[John]

If you already have data in the Adjacent cells cells you can double click on
the fill handle.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[David McRitchie]

Hi Rene,
You posted in the programming group so you got programming
solutions and one that was not. Since it doesn't really look like
a programming type of problem, I'll add another non programming
solution, which might have actually been done to help generated
the first solution you got.
Place formula in C1,
then place C1:C50000 in the name box at the left of the formula
bar -- glad to see you're not using all the rows. Then use Ctrl+D
to fill down.

Additional suggestions on filling down at
http://www.mvps.org/dmcritchie/excel/fillhand.htm

If you weren't using 50000 rows before doing that, you will be,
you want to keep the used range to what you actually need as
far as entering formulas on the worksheet is concerned.