Missing PivotFields Collection RRS feed

  • Question

  •    I am using VBA to create a Pivot Table. I set pvt to the pivot Table object. When I try to add a column I get an 'Object Required' error. When I inspect the pvt object I do not see a PivotFields member. How do I create this.

    Offending Line

     pvt.PivotFields("Date").Orientation = xlColumnField

    Tuesday, October 31, 2017 9:11 PM