VisibleItemsList is causing error: 1004

Using Excel 2007:

I'm trying to filter the pivot table and would like to select few values.

The code throws an error at VisibleItemsList. Please help.

A question was previously posted with the same problem:
http://www.excelforum.com/excel-prog...st-values.html

Please Login or Register  to view this content.

Any help will be appreciated.

Excel macro is producing the code with HiddenItemsList, but the value list is too long to capture and stops recording the macro.

Please Login or Register  to view this content.

The hierarchy is: Component -> MarketComponent -> Market -> Components

Thanks
-Kode