Results 1 to 3 of 3

Align Slicers on worksheet with Macro

Threaded View

  1. #1
    Registered User
    Join Date
    10-15-2011
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Align Slicers on worksheet with Macro

    I create repeatable reports where many slicers are used. The format calls for the slicer right and left edges to be butted up to one another, aligned top, same height. I current have to select all and distributed horizontally and adjust from there, seems fastest. The trick doing it that way is approximating the location of the left and right slicer, then manually adjust from there to make the right and left edges of the slicers meet. Placing them one at a time using snap to object is cumbersome too.
    I would like to create a macro that would select all the slicers, align by top, then snap the left edge of subsequent slicers to the right edge of the previous, distributing them to the right. I know it is possible and have seen other programs that do it, but don't know where to begin. Any help is greatly appreciated.
    (example attached)
    Thanks,
    Dave
    Attached Images Attached Images

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. Hidding/Locking [Protecting Worksheet] & Slicers issue
    By mattm11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2014, 01:22 AM
  3. 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
  4. 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
  5. [SOLVED] What is short-Cut forleft align and Right align?
    By Sandy in forum Excel General
    Replies: 1
    Last Post: 02-24-2005, 09:06 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