Thread: Pivot Tables in Macros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Skytree01 Skytree01 is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote