I have recorded a macro to create a pivot table and then copied the code into a macro but it seems to be falling down on the following line
Not sure why as it works OK when recording.
Any ideas anyone?
Thanks
Code:
ActiveSheet.PivotTables("Jan06").AddFields RowFields:=Array( _
"Job Number description", "Identifier"), ColumnFields:="Activity Description"
Any ideas anyone?
Thanks