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

Did you try hitting the record button , changing dates, then stop recording to see the 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