G
GoBucks
I found part of my answer in another post (see below) with the code:
ActiveSheet.Outline.SummaryRow = xlAbove
ActiveSheet.Range("A2", "A10").Rows.Group
But what if I wanted to Group other rows in the same worksheet in the same
fashion. For example, I would like to also apply for range A12:A20 with A11
as the row with the +/- sign. And then to A22:A30 with A21 as the row with
the +/- sign. And so on..
Also, I am fairly new to using VB, so what would be the entire set of code
to place in the in VB editor?
Thanks!!
http://www.microsoft.com/office/com...205f&mid=612b6e19-b928-4a43-ab9f-6c3c230b862e
ActiveSheet.Outline.SummaryRow = xlAbove
ActiveSheet.Range("A2", "A10").Rows.Group
But what if I wanted to Group other rows in the same worksheet in the same
fashion. For example, I would like to also apply for range A12:A20 with A11
as the row with the +/- sign. And then to A22:A30 with A21 as the row with
the +/- sign. And so on..
Also, I am fairly new to using VB, so what would be the entire set of code
to place in the in VB editor?
Thanks!!
http://www.microsoft.com/office/com...205f&mid=612b6e19-b928-4a43-ab9f-6c3c230b862e