Turn on the macro recorder and make the changes to the pivot table manually.
Turn off the macro recorder and look at the recorded code. This should be
where to begin.

Some more information may be found at Debra Dalgleish's site

http://www.contextures.com/tiptech.html

Look under P

--
Regards,
Tom Ogilvy


"Baileys Cigs" <Baileys wrote in message
...
I want to create a macro that lets you change the arrangement of a pivot
table. Need to know where to begin.