LinkBack URL
About LinkBacks
How can I loop through a slicer called Provider on a WS called Provider Names
The code below is what I use to execute each selection.
(Code modified by Jerry Beaucaires - Thanks Jerry)
Please Login or Register to view this content.
How can I loop through a slicer called Provider on a WS called Provider Names
The code below is what I use to execute each selection.
(Code modified by Jerry Beaucaires - Thanks Jerry)
Please Login or Register to view this content.
This should loop through the slicer items and call your PDF macro for each.
Please Login or Register to view this content.
Accessing the Slicer through VBA
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks AlphaFrog
Run time error 1004
Invalid Procedure Call or Argument
@For Each sli In ActiveWorkboo. . .
Look at the settings for the slicer (right click on the slicer and select slicer settings). Use the Name to use in Formulas name.Originally Posted by 3345james
slicer12.gif
The slicer name
Same issue - settings for formula = "Slicer_Provider"
Give this s try.
Please Login or Register to view this content.
still same error
@.VisibleSlicerItemsList = Array(sli.Name)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks