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
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.