I usually find it easiest to cheat and record the creation of a pivot
table, then tweak the pivottablewizard code... it's inelegant, but it
saves a lot of time!

Col


--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=545434