Trying to write Pivot table code from scratch is a pain. Tak
Microsoft's advice - record macros and edit them afterwards.

They tend to use the PivotTableWizard method

--
Message posted from http://www.ExcelForum.com