P
PeteCresswell
I've just discoverd .SubTotal
e.g.
------------------------------------------------------------
Selection.Subtotal
GroupBy:=4,
Function:=xlSum,
TotalList:=Array(9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
21, 22, 23, 24, 25, 26, 27, 28),
Replace:=True,
PageBreaks:=False,
SummaryBelowData:=True
------------------------------------------------------------
Seems to have promise to me. Especially after spending beaucoups man
hours writing code to allow the user to specify break totals on a
spreadsheet that he creates from an MS Access app..... and now having
the user say, "Oh, by the way...can you put the totals *before* the
details they apply to."
With .Subtotal, it's just a matter of flipping the SummaryBelowData
switch.
My problem is the cosmetics.
User want's to have the subtotal rows set to certain backcolors, have
bold borders applied, and force the "Total" labels to column 1 instead
of the column that's controlling the breaks.
Has anybody been successful in fine-tuning .SubTotal?
Doesn't seem tb any more syntax, but I figure maybe there's some API
ju-ju tb invoked.
e.g.
------------------------------------------------------------
Selection.Subtotal
GroupBy:=4,
Function:=xlSum,
TotalList:=Array(9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
21, 22, 23, 24, 25, 26, 27, 28),
Replace:=True,
PageBreaks:=False,
SummaryBelowData:=True
------------------------------------------------------------
Seems to have promise to me. Especially after spending beaucoups man
hours writing code to allow the user to specify break totals on a
spreadsheet that he creates from an MS Access app..... and now having
the user say, "Oh, by the way...can you put the totals *before* the
details they apply to."
With .Subtotal, it's just a matter of flipping the SummaryBelowData
switch.
My problem is the cosmetics.
User want's to have the subtotal rows set to certain backcolors, have
bold borders applied, and force the "Total" labels to column 1 instead
of the column that's controlling the breaks.
Has anybody been successful in fine-tuning .SubTotal?
Doesn't seem tb any more syntax, but I figure maybe there's some API
ju-ju tb invoked.