Results 1 to 3 of 3

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

Threaded View

  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.

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