View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default 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