Outline, expand or collapse via VBA

[Kevin McCartney]

Hi T.w.i.m.c,

I've exported a pivot query to excel and I've formatted the rows to be
grouped in a certain way that groups rows with the same level number to the
next parent level number and once complete an collapse all of the outlines.
Located in another column I have a True / False value that I want to use as
an idicator to expand that rows outline. In that I only need to expand
certain row outlines not all of them.

I was hoping that I could record a macro to get the syntax when a user
clicks on the plus sign but no code is stored, I've looked at row.outline but
this set the level, so is there a row property that indicated the row is a
parent of a group and the you can set the "Expand" property to True or False
or something like that.

Any ideas would be very much appreciated.

T.I.A
KM

 

[Kevin McCartney]

Doooooooooooooooooh,

ShowDetail is the propery ..... helps to look a little futher

KM