VBA to control Pivot Table Date Filter

Hi there!

I'm trying to write a macro that allows users to control the date filter on a pivot table by entering a start and end date into 2 cells. They then click a button that triggers the macro.

The code I have so far is:

Please Login or Register  to view this content.

This doesn't work, i get 'Application-defined or object-defined error'

I have also heard that this only works with the date format 'mm/dd/yyyy' so I have tried dates in that format and still no luck.

Any help would be greatly appreciated!

Adam

I am a massive massive tool and didn't spot my stupid mistake.

PivotFields("Faults") should have been PivotFields("Time Painted")!!