Results 1 to 3 of 3

Changing Names of Slicers is Prompting an Error

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-12-2018
    Location
    TX
    MS-Off Ver
    MS Office 2019
    Posts
    305

    Changing Names of Slicers is Prompting an Error

    Hello again. I'm getting an error (end/debug) message thrown when I change names of the slicers, both in the Data sheet and on the Slicer itself, and then try to update the PT or Reset the PT.
    The error is showing on Sheet2 (BuildMyBOM). Select any of the Items to the left and then select Reset. The line that is being highlighted is:
    If Not ActiveWorkbook.SlicerCaches(SlicerName).SlicerItems.Item(1).Value = "N/A" Then
    I’ve updated the Data sheet, I’ve updated the slicers, I’ve updated the code to the best of my abilities. I’m not sure where I’m going wrong. Would greatly appreciate if someone could take a look at it for me and provide some insight. Tks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Changing array names creates error
    By itsunclebill in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2015, 01:47 AM
  2. [SOLVED] Disconnect Slicers, Change Pivot Table Source, Reconnect Slicers: a problem
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:27 PM
  3. Replies: 1
    Last Post: 03-27-2014, 02:08 PM
  4. Replies: 9
    Last Post: 02-24-2014, 06:12 PM
  5. Changing Sheet Names based on cell value - Object doesnt support this property error
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-26-2013, 09:30 AM
  6. how to get "prompting of names" in a cell while entering data in excel07
    By cvsuryam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-30-2011, 05:26 AM
  7. Replies: 1
    Last Post: 12-02-2007, 12:51 PM

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