+ Reply to Thread
Results 1 to 3 of 3

[VBA] Slicer(s) / SlicerCache(s)

  1. #1
    Registered User
    Join Date
    09-10-2013
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    5

    [VBA] Slicer(s) / SlicerCache(s)

    I have two questions that I couldn't get advice from the other Excel Community, so maybe yall can help me. I am fairly new to VBA, trying to learn.

    1. Can someone give a nice explanation of the differences between SlicerCache and SlicerCaches? I am slowly starting to understand, but not fully.

    2. SlicerCache doesn't have a way to retrieve the Pivot Table name that it is associated with. Any simple way of doing so?
    Think I found it... SlicerCache PivotTables.Item(X)
    Last edited by Entellex; 06-08-2016 at 02:37 PM.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: [VBA] Slicer(s) / SlicerCache(s)

    1.
    basically
    you declare a Slicercache and you refer to Slicercaches

    below is example code of how it translate
    Please Login or Register  to view this content.
    2.
    not exactly sure what your asking but if you want to refer to an item in slicer
    you then need to get sliceritem (and sliceritems) involved

    http://www.contextures.com/excelslicersupdatevba.html
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    09-10-2013
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: [VBA] Slicer(s) / SlicerCache(s)

    Thank you for that

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Slicer
    By Kamalesh.shalini in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2016, 11:58 PM
  2. Lop through slicer until end
    By 3345james in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-19-2015, 09:35 PM
  3. Can I Sync a Slicer to Another Slicer If....
    By Polak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2015, 12:35 AM
  4. Make one slicer mirror filters of another slicer
    By IbenezPrez in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-28-2014, 02:00 PM
  5. [SOLVED] SlicerCache Exists But SlicerItems Throws 1004 Error
    By goss in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-24-2013, 03:59 PM
  6. Slicer Macro - unfilter another slicer on selection
    By chadheins in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2012, 10:41 AM
  7. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1