View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Excel Grouping and Hide

Sometimes, just recording a macro will show you the code that you need:

With ActiveSheet.Outline
.AutomaticStyles = False
.SummaryRow = xlAbove
.SummaryColumn = xlRight
End With


Bill wrote:

On Mar 26, 12:03 pm, JE McGimpsey wrote:
one way:

Data/Group and Outline/Settings, uncheck the "Summary rows below
detail" checkbox.

Which "hide feature" are you referring to?

In article .com,

wrote:
I am trying to figure out how to get rows to group up instead of down
so that when I expand, it iexands the detail below. It keeps adding
the +/- to the row below my selection instead of the top.


Also, I am a little confused as to what the hide feature does.
Anyone?
kbeandog


Anyone know how to do this from VBA (i.e. uncheck those boxes)?


--

Dave Peterson