G
G Lykos
Greetings! Am fumbling with the pivot table object, trying to work around
some idiosyncrasies. Would appreciate help on two things:
1. How do I read the cell value when a cursor is located in the data area,
and associate it with an item value or otherwise locate it in the data area
with respect to the framing fields/items so I can flag the row as not
..visible?
2. Is there an on-line description somewhere of how the parts of the pivot
table object fit together, and VBA access to them?
To give an idea where I'm at - it seems a little wild to need to read the
cell.pivotcell.parent value of a selected cell to discover the name of the
pivot table that the cell resides in, but maybe I just need to shake up the
hierarchical structure that my mind is struggling to impose on what may be a
different way of viewing things.
Thanks for any ideas!
George
some idiosyncrasies. Would appreciate help on two things:
1. How do I read the cell value when a cursor is located in the data area,
and associate it with an item value or otherwise locate it in the data area
with respect to the framing fields/items so I can flag the row as not
..visible?
2. Is there an on-line description somewhere of how the parts of the pivot
table object fit together, and VBA access to them?
To give an idea where I'm at - it seems a little wild to need to read the
cell.pivotcell.parent value of a selected cell to discover the name of the
pivot table that the cell resides in, but maybe I just need to shake up the
hierarchical structure that my mind is struggling to impose on what may be a
different way of viewing things.
Thanks for any ideas!
George