Insert a formula down 50,000 rows

R

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)
 
V

Vergel Adriano

Hi Rene,

Something like this:

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

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)
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top