Insert Copied Rows into existing Grouped Rows - VBA
I just started using Excel 2010 and am running into a problem I did not encounter in 2007. For my Report, I am grouping a list of rows together. At the end of the vba automation, I am inserting copied row cells into that group by using "Insert Copied Cells" which are an entire row. When I do this, however, It breaks the group up into two right at the insertion point. Is there a way to stop this from happening?
One solution would be to wait to group the cells after the inserted rows are in place, but this will require a re-write of my vba coding. Is there an option to turn on or off? VBA solution is best answer, but open to other suggestions. InsertCopiedRowIntoGroupedRows.jpg