When I interactively use the Data->Subtotals function, it creates the
subtotal lines and grand total line at the bottom, correctly per my
grouping column and subtotal columns. It also puts in "range bars" on
the left hand side that allows easy navigation, collapsing, expansion
of the subtotal groups.
When I do the same thing from c# code using the Range.Subtotal
function, using the same parameter values, I get only the subtotal
values and not the "range bars". Is that correct behavior? How do I
create those range bars from my code?
Thanks in advance,
CJJ
CJJ - 13 Feb 2007 18:39 GMT
> When I interactively use the Data->Subtotals function, it creates the
> subtotal lines and grand total line at the bottom, correctly per my
[quoted text clipped - 10 lines]
>
> CJJ
after further research, the "range bars" I allude to are actually
"Outlines". And the solution may lie in performing an "automatic
outline" operation on the range that includes the subtotal lines
Doug Glancy - 13 Feb 2007 18:46 GMT
CJJ,
Try doing it interactively with the Macro Recorder turned on. That could
show you your missing settings.
hth,
Doug
> When I interactively use the Data->Subtotals function, it creates the
> subtotal lines and grand total line at the bottom, correctly per my
[quoted text clipped - 10 lines]
>
> CJJ