Dynamic VBA code needed to filter pivot based on 2 cells

My start date is in cell C1.
My end date is in cell D1.

The field I want to adjust is

PivotTables("PivotTable1").PivotFields("Weekending")

I want it to show only the dates between the 2 cells. The date ranges in the field will always be different.

I am really struggling with this because whatever code I write I keep getting errors back. There must be a simple solution to this that is utterly evading me so I have come here for help.

If anyone could provide the code for this I would be incredibly grateful.

Ryan

Thank you for replying.

I am using 2007.

I have put that code in and I get "Application-defined or object-defined error".

This is a pivot table rather than an auto-filter list thing.

I get the same error.

.PivotFilters.Add Type:=xlDateBetween, Value1:=Format(Range("C1"), "dd/mm/yy"), Value2:=Format(Range("D1"), "dd/mm/yy")

Highlights the above in yellow. I made a dummy attachment with basic data but I dont see anywhere to put attachments on here.

I think I just attached.

I know where my issue lies now. Your code is definitely working with the dummy file. My only issue is the main excel file I am using has the filter for "between dates" greyed out for some reason. I need to figure out how to enable the between dates on my file and then I think I am away. However that is now proving elusive lol

They are most definitely all dates.

Image1.jpg

Cant add photo for some reason so here it is as attachment.

That is basically what I did with the dummy file and it worked. I need to be able to filter within this file and cant for the life of me figure out why the option is grayed out.