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.
Any ideas of how I could select the slicer by formula name would be great.
Thanks
Jim
Bookmarks