Results 1 to 22 of 22

Runtime error 438 in Pivot table macro

Threaded View

  1. #1
    Registered User
    Join Date
    10-08-2010
    Location
    North Yorkshire, England
    MS-Off Ver
    Excel 2003
    Posts
    69

    Runtime error 438 in Pivot table macro

    Hello
    Could someone please advise why I get a runtime 438 error in the following:


    Sub PivotStatus()

    Dim pt As PivotTable

    Set pt = Worksheets("Status TEST").PivotTables("PivotTable1")
    pt.PivotFields("Organisation").ClearAllFilters
    pt.PivotFields("Organisation").CurrentPage = Range("Pivot_Org")

    End Sub
    This is excel 2003

    thanks
    Last edited by DavidBW; 01-13-2012 at 07:17 AM. Reason: inserting code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1