Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / February 2007

Tip: Looking for answers? Try searching our database.

Range.Subtotal different than menu function

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CJJ - 13 Feb 2007 18:33 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.