Is there a way to limit the fields that are used in a
pivot table when adding with a VB procedure? For example,
I have a list of codes ranging from 1000 to 9000 that will
be used as the data source for a pivot table. However,
when I run code to add the pivot table, I want only codes
ranging between 7000 and 8999 to be in the pivot table.
Right now after adding the pivot I have to go through and
manually deselect all the codes I don't want, but this is
a great many codes.