Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically insert rows with formula | Excel Worksheet Functions | |||
how to insert rows by formula. | Excel Discussion (Misc queries) | |||
Formula to Insert Rows | Excel Worksheet Functions | |||
insert rows needs to copy formula | Excel Programming | |||
Insert rows, keep a formula? | Excel Worksheet Functions |