Collapsing Grouped rows by Macro

G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top