Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range.Subtotal different than menu function
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range.Subtotal different than menu function
On Feb 13, 10:33 am, "CJJ" wrote:
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 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range.Subtotal different than menu function
CJJ,
Try doing it interactively with the Macro Recorder turned on. That could show you your missing settings. hth, Doug "CJJ" wrote in message oups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtotal by a range | New Users to Excel | |||
Subtotal of Abs of a range? | Excel Worksheet Functions | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
range problem with multiple use of subtotal function | Excel Programming |