cscribner
10-09-2005, 12:50 PM
I just noticed, to my dismay, that the PivotTable dropdown on my Mac doesn't have any of the Grouping options I'm used to on my PC (year, quarter, etc.). Do the Group commands work in Mac's VBA?
eg.
'Group Date by Month, Quarter, Year
pt.PivotFields("Date").LabelRange.Group Start:=True, End:=True, Periods:=Array(False, False, False, False, True, True, True)
eg.
'Group Date by Month, Quarter, Year
pt.PivotFields("Date").LabelRange.Group Start:=True, End:=True, Periods:=Array(False, False, False, False, True, True, True)