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? |
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) |