Small but important problem:
I have a workbook that creates and manipulates pivot tables with various field settings. One of my fields is the "Queue" field- and I only display data in specific Queues. Therefore, the current code I have sets every Queue to false visibility. Then, another code sets only the Queue's I want to include to true visibility.
The problem is, sometimes the data I pull from does not contain all of the Queues- so my macro will crash because it tries to set a Queue's visibility to false- when that Queue does not exist in the data.
If there were some way of setting ALL the "Queue" fields to false visibility- without specificing each Queue- then the code would work no matter what. It would change all Queues to false, and then show the ones I want (The Queue's I need to be visible are always present in the data). Ideas anyone? Attached is the code.
Bookmarks