Slicers -- Change ' Name to use in formulas ' value of the Slicer Setting

Dear all,

I have a requirement to add Slicer and modify Slicer settings.

I use the following code to create "Age" Slicer for the field "Age" referring to the Pivot table " PivotTable1 " whose Name is "Age_Slicer" and Caption is " Age Values "

Please Login or Register  to view this content.

However, I need to modify the Slicer to have the Age values to be displayed over 5 columns. I recorded my action and see the following auto-generated code:

Please Login or Register  to view this content.

I understand that I need to get control of the Slicer setting ' Name to use in formulas ' to be able to achieve my goal. Currently, i'm unable to do the same.

Request your help to be able to define the Slicer setting ' Name to use in formulas ' through VBA

This is very important as I have to create multiple Slicers for various Pivot Tables and "Age" field is the most common Slicer that I would need.

Thanks,
Vinod Krishna

Here is the solution guys:

let's say "Slicer_Age" is the ' Name to use in formulas ' of the Slicer Setting.

Please Login or Register  to view this content.

Name parameter is just after choosing the field parameter