Mark Simms
marksimms at verizon.net
Sat Oct 29 09:14:19 CDT 2011
Just reference the entire worksheet (change activesheet below to
worksheets("whatever") if required).
My notes on this function indicate to put a Application.DisplayAlerts=False
statement in there too.
>
> With ApXL
>
> .ActiveSheet.Subtotal GroupBy:=4, Function:=xlSum,
> TotalList:=Array(12), _
>
> Replace:=True, PageBreaks:=False, SummaryBelowData:=True
>
> .ActiveSheet.Outline.ShowLevels RowLevels:=2
>
> .Columns("L:L").Style = "Currency"
>
> .Rows("1:1").Font.Bold = True
>