Hello

I am setting up a workbook that contains slicers on multiple sheets. The slicers will use the same field name and as is the case with slicers Excel will append a number so they are unique. I need to reference the slicer so I can move it and set the size.

It doesn't feel right to reference the number that I think Excel will have assigned so I have tried to do it by the formula name (given when adding the slicer).

Is it possible to select, position, or size a slicer based on the formula name?
The code below doesn't seem to be working.

Please Login or Register  to view this content.
Any ideas of how I could select the slicer by formula name would be great.

Thanks

Jim