| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to add rows
see Insert a Row using a Macro to maintain formula
http://www.mvps.org/dmcritchie/excel/insrtrow.htm You will have to modify your formulas to use OFFSET as described. --- 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 "belvy123" I need to create a macro to add 10 rows to my sheet at the end of the rows where I enter my production data., I need this to carry my function into these new rows as well. Any ideas would be greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help (Uppercase multiple ranges?) | Excel Discussion (Misc queries) | |||
| Macro Help - Indefinite Rows | Excel Discussion (Misc queries) | |||
| How can I invoke running a macro from within an "IF" function. | Excel Worksheet Functions | |||
| Macro to delete rows with same data | Excel Worksheet Functions | |||
| Macro Help In Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
