This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 30%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Hey,
I have a problem with my macro for automatic selecting yesterday (so tomorrow i want an overview of today, or simple day -1).
And this overview has to be in the setup like the attached picture "capture.jpg". So it's a worksheet containing slicers, pivot table and pivot chart.
My current problem is when i run the macro, i get the overview of the entire month instead of only yesterday.
I attached my macro in the picture "macro.jpg".
Could anyone help me with this ?
Does it work if you manipulate this sheet manually, not by macro?
Everything works when i manually select the date i want... So all the connections between the chart, slicer and table are working.
The macro also work, but when i run the macro it 's selecting everyday before yesterday. Not only yesterday...
Did you investigate the values of .SlicerItems(i).Name and variables, and did you check if the condition .SlicerItems(i).Name <> myDay works as expected?
Hey,
I added the file. Maybe you can test something ...
I tried everything in range of my knowledge, but i don't know what to do anymore ...
So i hope somebody can see what i did wrong ...