Not too sure I understand the question, but the links below may help?
http://www.ozgrid.com/VBA/pivot-table-fields.htm
http://www.ozgrid.com/VBA/hide-pivot-fields.htm



--
Regards
Dave Hawley
www.ozgrid.com
"George" wrote in message
...
I have a spreadsheet with three pivot-tables. When an item is selected in
the first pivot-table the other pivot-tables items are changed. How can I
reference a specific item in a pivot-table using VBA?

Thank you,
George