| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Insert Multiple rows
I want to have a macro or shortcut which i can use to insert rows to
spreadsheet, so if i run the macro it will ask how many rows i want to isert and at between which rows then add that no of rows and alter formulae to include new rows |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Insert Multiple rows
David McRitchie has some code to insert rows and copy formulas at:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm look for: InsertRowsAndFillFormulas If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Colm wrote: I want to have a macro or shortcut which i can use to insert rows to spreadsheet, so if i run the macro it will ask how many rows i want to isert and at between which rows then add that no of rows and alter formulae to include new rows -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to protect some cells, but able to insert rows elsewhere? | Excel Discussion (Misc queries) | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| Insert a specified number of rows dynamically | Excel Worksheet Functions | |||
| Insert Multiple Rows | Excel Discussion (Misc queries) | |||
| INSERT ROWS WITHOUT SCREWING-UP FORMULAS! | Excel Worksheet Functions | |||
Linear Mode
