Hi All,

Does anyone know how to expand the outline in one subtotal? I have a
group of subtotals for which I have used ActiveSheet.Outline.ShowLevels
RowLevels:=2 to display only the summary information. I then search for
one of the subtotals and I want ot expand only that one subtotal. Just
like when you click on the small + button on the side of the sheet.
Recording a macro does not produce anything and selecting the row as a
range and trying to change the outline level also does not work. It
seems you can only change the entire outline by changing RowLevels to
3.

Any ideas?

TIA
Mike



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/