+ Reply to Thread
Results 1 to 3 of 3

Select Date Range from a Slicer with macro

  1. #1
    Registered User
    Join Date
    08-08-2014
    Location
    usa
    MS-Off Ver
    MS7
    Posts
    2

    Post Select Date Range from a Slicer with macro

    Hello -

    I would like to know how can you select a date range from a slicer using a macro. I have a (Date) slicer displaying dates from last year to current day and i want to create a macro to select the last 7 days from today's date each time i run it. Does anyone knows how to do that?

    Thank you

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,022

    Re: Select Date Range from a Slicer with macro

    Did you try hitting the record button , changing dates, then stop recording to see the macro?

  3. #3
    Registered User
    Join Date
    08-08-2014
    Location
    usa
    MS-Off Ver
    MS7
    Posts
    2

    Re: Select Date Range from a Slicer with macro

    Thank you for your reply - yes i sure did this but my problem is that the dates on my slicer are not static they change daily when i refresh to give me the new current date. So every day i need to select the new current day plus the 7 last days. So i am trying to create a macro that does this automatically. To first refresh the data, then select the curent date and the last consecutive 7 dates.

    Any sugesstions?
    Thanks

+ 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. Newbie: Auto Select/un-Select an Range of Slicer Items
    By luckyali in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2014, 09:52 AM
  2. Select fields in slicer with macro
    By joelvankesteren in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-13-2014, 02:21 AM
  3. Macro to select date range in slicer
    By handerson0603 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2013, 03:06 PM
  4. Replies: 0
    Last Post: 04-04-2013, 02:30 AM
  5. 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

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