Insert a formula down 50,000 rows
 

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

Insert a formula down 50,000 rows
 

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

Insert a formula down 50,000 rows
 

or even -

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

Regards,
Peter T

"Vergel Adriano" wrote in message
...
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

Insert a formula down 50,000 rows
 

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)


"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

Insert a formula down 50,000 rows
 

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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.