View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Philip J Smith Philip J Smith is offline
external usenet poster
 
Posts: 80
Default 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?