+ Reply to Thread
Results 1 to 2 of 2

Iteration with slicer not working in Excel VBA

  1. #1
    Registered User
    Join Date
    09-22-2021
    Location
    Montreal, Canada
    MS-Off Ver
    2008
    Posts
    2

    Iteration with slicer not working in Excel VBA

    This is what I'm trying to do : I would like a new copy of my Excel file to be saved for each item (individually) in my slicer when running my macro. The problem is that every time I run it, there is something wrong with my For Loop here "For Each slItem In slBox.SlicerItems" that I don't understand. The error is : Run-time error '1004': Apllication-defined or object-defined error. YRl37.png

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    09-22-2021
    Location
    Montreal, Canada
    MS-Off Ver
    2008
    Posts
    2

    Re: Iteration with slicer not working in Excel VBA

    I am open to listening to all other possible alternatives to this vba macro

+ 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. Timeline Slicer Not Working with Blanks from Date Formula
    By dkramer_AZ in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-10-2020, 04:32 PM
  2. Excel Timeline Slicer not working in formula for days
    By TheCman81 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-11-2019, 02:34 PM
  3. Run an entire loop instead of iteration by iteration when stepping into code?
    By Norcal1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2019, 04:20 PM
  4. Paste Special not working on 2nd iteration
    By j_Southern in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2018, 10:29 AM
  5. Stepping through pivot table w slicer data using vba not working
    By rvaldivia in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-06-2018, 11:04 AM
  6. Loop through slicer, while also selecting single slicer value on separate slicer
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2018, 01:41 PM
  7. Replies: 1
    Last Post: 04-23-2018, 09:43 AM

Tags for this Thread

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