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