Colored text might work between code tags but bolding doesn't. Can't tell which line is generating the error.
Try color or 'comment on the line.
Each has a date filter, the field for every pivot table is named date, each has the same set of dates
Every week this spreadsheet is updated with another set of data for the previous week, and the customer needs the date filter to have the latest three dates selected.
I don't get where all these dates are coming from. If each pt has the same dates, where are the "latest three dates" coming from. Selected from where, the pt? The spreadsheet that the pt is on?
EDIT: after re-reading, this isn't Automation from Access as I first thought. It looks like it's purely Excel, but you are posting vba code in an Access forum in the Macros section?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.