I'm trying to automate a report and the first step is selecting a group of names from a slicer. I tried to get a base macro by recording but it only showed me selecting a sheet and a cell on the sheet. Below is a picture of what I'm trying to do. The names in blue are what I'm trying to select.
VBA.PNG
What is your slicer based on?
Is it OLAP Data model based or based on PivotTable built using traditional method (i.e. from Excel range/table)?
Or is slicer connected Excel Table.
Code will differ significantly based on how slicercache is built. Please upload desensitized sample file, it would make it so much easier to help you.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks