Hey All!

I'm trying to create a macro that will filter my pivot table row label. If the row label "Date" has the same month as the current month, I want it to show.

I have the following idea: 

Please Login or Register  to view this content.
But this gives me a runtime error 5. I think it's the Value1, which cannot be a variable? Any ideas?

Thanks in advance!