Select specific PivotItem

Hi All,

Is there a method or property similar to "CurrentPage" (please see the following code sentence where "Estado_comisión" is set as page filter), which I can apply to select only one item of a pivotfield, instead of my actual procedure of switching visible property TRUE for all pivotitems in a row pivot field and then swithching FALSE all undesired values within a for...next loop?.

Please Login or Register  to view this content.

Thank you
selopezr

To answer your question - not that I'm aware of
(1 item must be visible at all times hence show all then hide all but 1)

Note: the above does not mean it's categorically impossible... just that I don't know of a practical approach

However, if you toggle screenupdating, ManualUpdate etc as part of the process the iteration should not too much of a drag.

edit: you could also look to utilise and iterate the VisibleItems collection rather than all items (having ensure the valid selection is visible first of course)