View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nickd via OfficeKB.com nickd via OfficeKB.com is offline
external usenet poster
 
Posts: 8
Default Pivot table macro

I have recorded a macro which creates a pivot table, when the macro runs
there is a run time error, at in the in VBA code whic is as follows :

ActiveSheet.PivotTables("PivotTable3").AddFields RowFields:=Array( _
"Payment Type 2", "Data")

Ant help appreciated.

Thanks

--
Message posted via http://www.officekb.com