Group Years, how to do it?

[scardy]

Hi.
on a pivot table I have a field button "OpenDate"on the Category
field section.
Selecting the field button "OpenDate" and clicking the right button I
select "Group and Show details" and then "Group". At this point I group
by "Years".
Is it possible to describe all these steps through Visual basic code?

many thanks to everybody

regards
Scardy

 

[Ardus Petus]

Did you try recording a new macro while running these steps manually?

HTH

 

[scardy]

Sure!! I tried recording a new macro while running these steps manually
but Excel doesn't record anything!

Is there an alternative way?

Thanks