Pivot Tables

Hi Stephen

In VBA to set a Pivot Field in the Page Section of the Pivot Table you write:

ActiveSheet.PivotTables("SalesInfo").PivotFields ("Salesperson").Orientation = xlPageField

To remove it from the area so a new field can replace it you write:

ActiveSheet.PivotTables("SalesInfo").PivotFields ("Salesperson").Orientation = xlHidden

Hope this helps

Carlos