Pivot change date range auto

[Villalobos]

Hello,

I would like to filter my pivot table between two dates, but something is not working for me. The dates are in the row label field.
Please, could somebody tell me why doesn't work for me and how should I modify it?

Please Login or Register  to view this content.

The sample file has been attached also.
Thanks in advance the reply!

[PCI]

See how next piece of code can help
Startdate is for H2 and EdndDate for H3

Please Login or Register  to view this content.

[Villalobos]

Hello PCI,

Unfortunately I get Application-defined or object definied error msg.

[Villalobos]

Please, ignore my last post, your advice is working.

Thank you for the help!