| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to insert row and copy previous row + excel
I have a named range First_Table (A5:AB30 ) and a named range End_Table (A30).
I would like to insert a row above the named range End_Table (A30). Then copy the contents and formula from cells F29:AB29 into the new row. However every time I run the macro it seems to insert the new row in a different place which is messing up my data. Can anyone help me please? -- Laura |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 - how to insert row with formats and totals of previous | Excel Discussion (Misc queries) | |||
| Copy Insert Macro | Excel Discussion (Misc queries) | |||
| Macro - Insert/Copy | Excel Discussion (Misc queries) | |||
| Need A Macro To Copy Previous Tab to New Tab | Excel Discussion (Misc queries) | |||
| Macro to copy previous row and insert two blank rows | Excel Discussion (Misc queries) | |||
Threaded Mode
