Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Demyan Nonob   on Sep 02 In MS Office Category.

  
Question Answered By: Julia Flores   on Sep 02

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.

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Find the name of the pivot table on the activesheet Or get search suggestion and latest updates.


Tagged: