Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel - Automatically Extending Formulas
Hi,
I have a large worksheet that has a number of fairly complex formulas that are repeated in each row with only the row number reference changing. When I insert a new row in between two existing rows that contain formulas I would like excel to automatically insert the formulas I have in the row above it into my new row. Excel already does this with my formatting, I want to know how to do it with my formulas as well. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel - Automatically Extending Formulas
Hi Cadillac. If you copy the entire row, above the one where you are going
to insert a new row, and then paste insert row, the formulas will be copied and the cell references will change. HTH -- Sincerely, Michael Colvin "Cadillac Williams" wrote: Hi, I have a large worksheet that has a number of fairly complex formulas that are repeated in each row with only the row number reference changing. When I insert a new row in between two existing rows that contain formulas I would like excel to automatically insert the formulas I have in the row above it into my new row. Excel already does this with my formatting, I want to know how to do it with my formulas as well. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel - Automatically Extending Formulas
How about if you put your formulas in row 1hide the rowdouble click
right click sheet tabview codeinsert this. Now, when you double click anywhere on the sheet row will be inserted before the last row and row 1 will be copied. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) lr = Cells(Rows.Count, "a").End(xlUp).Row Rows(lr).Insert Rows(1).Copy Rows(lr) End Sub -- Don Guillett SalesAid Software "Cadillac Williams" <Cadillac wrote in message ... Hi, I have a large worksheet that has a number of fairly complex formulas that are repeated in each row with only the row number reference changing. When I insert a new row in between two existing rows that contain formulas I would like excel to automatically insert the formulas I have in the row above it into my new row. Excel already does this with my formatting, I want to know how to do it with my formulas as well. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. | Excel Discussion (Misc queries) | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
Filename at the very top of Microsoft Excel Window | Excel Discussion (Misc queries) |