I am trying to test the PivotTable to see if I have already added the Date field. This is the code I am using:
[VBA]
if Not PT.ColumnFields = "Date" Then
ptReportOptions objDataForm
End If
[/VBA]
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 there