VB Macro for Pivot Filter Function

[Gaura215]

Dear All

I have a recorded a macro to create a Pivot table from my data. In this Pivot I have to make the report filter field to filter the dates from the current month only. Is there a way that I can instruct my macro that in that filter it automatically filter the data from the current month range.

I am amatuer in VB stuff and seek help from all excel gurus.<!-- google_ad_section_end -->

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?641226-VB-Macro-for-Pivot-Filter-Function

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).