Pivot Table Macro

[Steven]

I think I am getting very lazy. I have been trying to make the Row Field
Ascending with the following generic macro but with no sucess.

ActiveCell.PivotField.AutoSortField xlAscending

What am I doing wrong?

Thank you,

Steven

 

[ryguy7272]

Turn on your macro recorder, double-click on an item on the row element of
your Pivot Table (or whatever you want to sort by), Advanced > Ascending > Ok

Ok. Look at the code and edit as necessary.

I believe that will give you what you want.

Regards,
Ryan---