I have also tried this:
I get the same error..![]()
Sheets("LecDaily").Select ActiveSheet.PivotTables("InboundCalls").PivotFields("[CallDates]").AddPageItem _ "[CallDates].[All CallDates].[" & strYear & "].[" & strMonthName & "].[" & strDay & "], True"
I would really appreciate assistance if anyone has an idea...
Bookmarks