Yes, I may need to explain further. I have about 8 sheets that I
create and put pivot tables on. This is done after I pull data out of
an Oracle database with sql. The I create charts based on the tables.
This is all being done with code, but I am manually going in and hiding
some of the data fields if they contain no information so my chart will
be less cluttered. I have a loop to determine which items need to be
turned off, but now I want to apply this to every pivot on every
sheet. I am using ActiveSheet to do the process of finding empty
values, but when I try to apply this loop to the next sheet I need to
know the name of the pivot on that sheet. I am currently using the
name of the one that is on the sheet I am debugging on but I typed it
in manually. I could just hard code the routine for each page bt I
would rather reuse the code and just apply it to each sheet.