M
mark
Hi.
I'm using the subtotal method of the range object to create subtotals.
This method appears to either create or at least update the Outline object
of the worksheet.
The user would like to have a blank row above and below her subtotals which
are created using the subtotal method. When these are inserted, they are not
included in the groupings created by the subtotal method, so when you ask the
spreadsheet to display the outline at rowlevels:=2, it still shows the blank
lines.
I've looked in the help, and don't see much about how the Outline is
created, or how to manipulate it in code.
If Rows 31 to 40 are in a single group, is there a way to insert a new row
above the current row 31 which is still grouped in the group that was row 31
to 40?
Thanks.
Mark
I'm using the subtotal method of the range object to create subtotals.
This method appears to either create or at least update the Outline object
of the worksheet.
The user would like to have a blank row above and below her subtotals which
are created using the subtotal method. When these are inserted, they are not
included in the groupings created by the subtotal method, so when you ask the
spreadsheet to display the outline at rowlevels:=2, it still shows the blank
lines.
I've looked in the help, and don't see much about how the Outline is
created, or how to manipulate it in code.
If Rows 31 to 40 are in a single group, is there a way to insert a new row
above the current row 31 which is still grouped in the group that was row 31
to 40?
Thanks.
Mark