VBA Subtotal question

The SUBTOTAL function in Excel will subtotal a list and show an outline
control on the left of the screen. The outline control allows the user to
change the amount of data shown in the sheet (data with subtotals, only
subtotals or only grand total). Can this outline control be programmed via
VBA? I would like to have a list that only shows the subtotals (without the
source data displayed)? Will I have to switch to a Pivot Table to
accomplish this task?

Thanks

Record a macro when you show/hide the data you want.

You'll see code like:

ActiveSheet.Outline.ShowLevels RowLevels:=1
ActiveSheet.Outline.ShowLevels RowLevels:=2
ActiveSheet.Outline.ShowLevels RowLevels:=3



hooper wrote:
>
> The SUBTOTAL function in Excel will subtotal a list and show an outline
> control on the left of the screen. The outline control allows the user to
> change the amount of data shown in the sheet (data with subtotals, only
> subtotals or only grand total). Can this outline control be programmed via
> VBA? I would like to have a list that only shows the subtotals (without the
> source data displayed)? Will I have to switch to a Pivot Table to
> accomplish this task?
>
> Thanks

--

Dave Peterson