Hi,
I have a Workbook with a lot of PivotTables on it.
I am trying to change the date on the filter to todays date..
Can someone guide me whats wrong with this code? I am unable to get it to work for some reason..
But, when I change it to this line, it suddenly worksPlease Login or Register to view this content.
I also have the Date in my underlying data returned by the Date function.Please Login or Register to view this content.
This is the code generated by the Macro Recorder, but that does not work when done using a variable or even a hard coded value for that matter
Please Login or Register to view this content.
Bookmarks