You have to sort the table based on the value in a row field.

--
Regards,
Tom Ogilvy


"RADO" wrote in message
...
I will appreciate advice on how to sort a desired pivot table column field
in VBA.

I tried Sort method, but VBA help is very unclear on how to use it with
pivot tables. What should be "key1" in this case?

Thanks in advance -

RADO