+ Reply to Thread
Results 1 to 1 of 1

Help with macro with slicers

  1. #1
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Austria
    MS-Off Ver
    Excel 2016
    Posts
    165

    Help with macro with slicers

    Hi everyone,

    I built a macro that goes through all items of a selected slicer. At each item it copies the values I checked on the userform checkboxes. But I have a problem and can not handle it.
    The problem is that the macro does not go to the first cell with a value in column A when 2 or more slicers are activated. And (sometimes) I get an error message that comes from the "filter" macro.
    Can you please help me?
    My idea was to create a macro, that can filter and copy a lot of data in a short time.
    Thanks a lot for your help!

    Kind Regards
    Roman
    Attached Files Attached Files

+ 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. [SOLVED] Macro to Run when Slicer Selection is Changed (multiple slicers)
    By jcanlas in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-09-2021, 11:41 AM
  2. Using Slicers
    By JakeMann in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-29-2016, 08:50 AM
  3. Slicers on a MAC?
    By horsefish01 in forum Excel General
    Replies: 0
    Last Post: 11-23-2015, 03:02 PM
  4. [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
  5. Align Slicers on worksheet with Macro
    By dkmanley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2015, 11:00 AM
  6. Excel 2010 Slicers : use vba macro to only select last date listed ( always Now - 1 )
    By spencerpritchard in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2014, 02:25 PM
  7. Can a macro make selections to slicers based on values or criteria in cells?
    By Yas420 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2013, 03:07 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