Selecting the current month using a macro on a pivot table



I have a macro set to run every day. In the pivot table it chooses Nov. How
can I get this to choose the current month so that I don't have to change it
every month. Also can make the change to current month on the 5th business
day to the current month?

ActiveSheet.PivotTables("PivotTable2").AddFields ColumnFields:= _
With ActiveSheet.PivotTables("PivotTable2").PivotFields("NOV")
.Orientation = xlDataField
.Caption = "Sum of NOV"
.Function = xlSum

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question