Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Outline Object
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
Option button object proeprties or object not found in vba | Excel Programming | |||
Confusion about how the Window object fits into the Excel object model | Excel Programming | |||
returning pivottable object from a range object | Excel Programming |