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.
[VBA]'Group Date by Month, Quarter, Year
pt.PivotFields("Date").LabelRange.Group Start:=True, End:=True, Periods:=Array(False, False, False, False, True, True, True)[/VBA]
Reply With Quote
)
