cancel
Showing results for 
Search instead for 
Did you mean: 

Amend Pivot Table VBA to remove multiple Items

FrancesBarker
Level 3

Hi,

I created a code stage in my Excel VBO Extended to Select all then exclude certain values from the pivot table filter.  However I am not a coder and would like to be able to pass in a variable no of values to exclude in a collection.

Here is my current code that excludes 2 values.  But I may have 3 or 4 or 1.  Please can someone kindly help me? Thanks.

FrancesBarker_1-1737972540141.png

 

 

 

 

0 REPLIES 0