Pivot Tables in Macros
 

I'm having trouble adding more than one data field to a pivot table.
I've tried messing around with:
With Pt
.PivotFields(strField9).Orientation = xlDataField
.PivotFields(strField10).Orientation = xlDataField
End With

and doing it in seperate With statements and as an array, but nothin
seems to work

--
Skytree0
-----------------------------------------------------------------------
Skytree01's Profile: http://www.excelforum.com/member.php...fo&userid=3350
View this thread: http://www.excelforum.com/showthread.php?threadid=53299