Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add new rows
i have row that i need to have copied and inserted directly beneath the
original row preserving all of the rows formulas and cell formatting. currently, the row i am referring to is a combination of four rows. for example, A2, A3, A4, and A5 are merged, as are B2, B3, B4, B5. however, this pattern is not continued across all of the columns of the row. C1, D1, E1 are merged and therefore one cell. C3, C4, and C5 are not merged (neither are cells D3, D4, and D5). E3 and E4 are merged together. A pattern similar to this continues until column I, where the spreadsheet ends. I need some sort of a button that the user can press that will automatically insert the exact row directly beneath the row referred to above. If not a button, then a box in which a user can input the amount of rows they wish to have. I've been working on this for days now and have gotten basically nowhere. Any help would be greatly appreciated. Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
add new rows
see
Insert a Row using a Macro to maintain formulas http://www.mvps.org/dmcritchie/excel/insrtrow.htm it is only set up to insert below one row it is not set up to work with merged cells, you have to insert 4 rows before the row after the 4 rows being copied. Then paste the original four rows to the new four rows, in the new four rows select cells without formulas and clear them with special cells . -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "NewAccessUser" wrote in message ... i have row that i need to have copied and inserted directly beneath the original row preserving all of the rows formulas and cell formatting. currently, the row i am referring to is a combination of four rows. for example, A2, A3, A4, and A5 are merged, as are B2, B3, B4, B5. however, this pattern is not continued across all of the columns of the row. C1, D1, E1 are merged and therefore one cell. C3, C4, and C5 are not merged (neither are cells D3, D4, and D5). E3 and E4 are merged together. A pattern similar to this continues until column I, where the spreadsheet ends. I need some sort of a button that the user can press that will automatically insert the exact row directly beneath the row referred to above. If not a button, then a box in which a user can input the amount of rows they wish to have. I've been working on this for days now and have gotten basically nowhere. Any help would be greatly appreciated. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto extract data & inserts rows additional rows automatically | Excel Discussion (Misc queries) | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
"Add/Remove Rows Code" adds rows on grouped sheets, but won't remove rows. | Excel Programming | |||
Copy pasting Rows, but need to Delete any Shapes/Pictures that are within copied rows | Excel Programming | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) |