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

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---


--
RyGuy


"Steven" wrote:

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