Microsoft Excel - filter a date in a pivot table based on the content of a cell

Hi,
I have this code that allows me to filter a date in a pivotable based on cell G1. How to modify the code to filter the date between two dates based on cell G1 and G2. Thanks.

Sub Worksheet_Change()

ActiveSheet.PivotTables("PivotTable1").PivotFields("Date").CurrentPage = Range("G1").Text

End Sub

Hi,

Have you tried using Range("G1").value instead?

I use this on some of my workbooks and it seems to work.

Cheers

Pete

Thanks. I want to filter dates based on startdate & Enddate from two ranges. And yes, I can use Range("G1").value for startdate but I need to use also Range("G2").value for Enddate.