Hi all,

I have created a pivot table using VBA but this pivot table shows al
the data within the table and I only want to show selected parts of
field.

I.e. Within "Column 1" I only want to see the numbers 1, 2, 3 and
(the list goes upto about 50).



With Pt.PivotFields("Column 1")
.Orientation = xlRowField
.Position = 2
End Wit

--
moglione
-----------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...fo&userid=2641
View this thread: http://www.excelforum.com/showthread.php?threadid=54993