Consulting

Results 1 to 5 of 5

Thread: Solved: Test if a Column Field Exists in Pivot Table

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Master
    Joined
    Jun 2006
    Posts
    1,091
    Location

    Solved: Test if a Column Field Exists in Pivot Table

    I am trying to test the PivotTable to see if I have already added the Date field. This is the code I am using:

    if Not PT.ColumnFields = "Date" Then
        ptReportOptions objDataForm
            End If
    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
    Last edited by Aussiebear; 03-16-2025 at 11:38 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •