| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting rows with formulas
Hi
Does anyone know how to code a button on the worksheet to insert 2 rows above the active cell and then copy the formulas down (or up) from the rows that are adjacent? Many thanks Ken |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
inserting rows with formulas
This should work, adjust ColumnToFill as needed.
Dim R As Integer, ColumnToFill As Integer R = ActiveCell.Row ColumnToFill = 1 ActiveCell.EntireRow.Insert Range(Cells(R - 1, ColumnToFill), Cells(R, ColumnToFill)).FillDown -- Regards, Rocky McKinley "~Ken~" wrote in message ... Hi Does anyone know how to code a button on the worksheet to insert 2 rows above the active cell and then copy the formulas down (or up) from the rows that are adjacent? Many thanks Ken |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying formulas when inserting new rows | Excel Discussion (Misc queries) | |||
| Copy Formulas when inserting rows | Excel Discussion (Misc queries) | |||
| Inserting formulas etc after n rows | Excel Discussion (Misc queries) | |||
| Inserting Rows w/formulas question | Excel Worksheet Functions | |||
| Inserting Multiple Rows with Formulas | Excel Worksheet Functions | |||
Linear Mode
