Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collapsing Grouped rows by Macro
I have a report which contains some grouped rows.
In each case the rows are grouped into a total above. The working status of the groups should be all rows desplayed. Before printing I would like to collapse some of the groups so that only the totals are shown. I have tried. Range("NewPLTradeIncome").OutlineLevel = 1 This fails: I get the error report "Unable to set the OutlineLevel property of the range class" Can anyone point me in the right direction please? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collapsing Grouped rows by Macro
Turn on the macro recorder and then manually collapse the rows.
Now expand them. Turn off the macro recorder. Look at the recorded code. It should give you some insight into what you need to do. -- Regards, Tom Ogilvy "Philip J Smith" wrote: I have a report which contains some grouped rows. In each case the rows are grouped into a total above. The working status of the groups should be all rows desplayed. Before printing I would like to collapse some of the groups so that only the totals are shown. I have tried. Range("NewPLTradeIncome").OutlineLevel = 1 This fails: I get the error report "Unable to set the OutlineLevel property of the range class" Can anyone point me in the right direction please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard shortcut for expanding/collapsing grouped rows | Excel Discussion (Misc queries) | |||
Collapsing/expanding grouped areas on multiple pages | Excel Worksheet Functions | |||
collapsing rows together | Excel Worksheet Functions | |||
collapsing rows | Excel Worksheet Functions | |||
Collapsing Rows | Excel Discussion (Misc queries) |