I am trying to test the PivotTable to see if I have already added the Date field. This is the code I am using:
However, it says that object doesn't support that property. PT is the pivottable that I have created and ptReportOptions is the sub I want it to run if it works. Unfortunately it crashes on the first line thereif Not PT.ColumnFields = "Date" Then ptReportOptions objDataForm End If