How to auto select from a Slicer last or top item

[xtrenge]

Hello there, i'm very new in vba and i've been searching for an answer from a lot of sites, but nothing yet done, here's the thing:

I've some slicers using daily "date" obtained from pivot table and from cube connection, it's not good to me viewing all days of the year or past year, etc. i wish to know if it's possible to auto select the last day from a specific slicer like:

date.png

Is possible to me see if the slicer exists with "Exists" result:

Please Login or Register  to view this content.

I don't really know how to start this, could be using some of this?:

Please Login or Register  to view this content.

Well hope this helps to see what i need, thanks in advance for any clue to solve this

Very Sorry if this post should be in " Excel Programming / VBA / Macros " instead of here, i hope some admin could change it where it belongs, thanks