Iterate over only visible pivot items

[kaptenstofil]

Hi all,

I have a PivotTable with a number of strings in the Row Label-field, together with corresponding numeric values in the Values-field. The below code goes through all strings and stores each unique item from the Row Label in a variable named tmp.

However, I'm in the need of filtering this Pivot with a value-filter and then be able to run the code only catching the visible items. If I apply a label filter the code catches just the visible items, but apparently the .Visible-property do not catch items that were filtered out based on the value filter.

Do you guys have any idea if this is possible to achieve?

Many thanks and best regards,

Please Login or Register  to view this content.

[dflak]

You can "overlay" the results of the pivot table with a named dynamic range and use it in your VB code. http://www.utteraccess.com/wiki/inde...Dynamic_Ranges.