G
Guest
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
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
