Pivot Table Macro Help

[jtwusmc]

Morning forum.
I'm building a macro to delete all contents in the column filed of a pivot table, then add a new field in it. My goal is to get it to work off a dropdown list so the user can select what they want to view/compare (in the Column field) in the table.

Below is what I have so far. It run's without error, but the part that deletes the contents of the column field is not working. It will add the new field (i.e. "Mgr3" ), but it's just not deleting all the fields in the column field prior to that.

Please Login or Register  to view this content.

[judgeh59]

one thing you might try is putting a period before the Orientation in that area....also, maybe try using .visible = False instead of orientation...just a thought...