Results 1 to 7 of 7

Need help in error '9'

Threaded View

  1. #1
    Registered User
    Join Date
    04-29-2006
    Posts
    68

    Need help in error '9'

    Gentlemen,
    I try to build sorting code, but I face error '9'

    Sub Sort()
    Application.ScreenUpdating = False
    Sheets("PivotTable1").PivotTables("PivotTable1").PivotFields("Emp Name").AutoSort _
            [drpSortMethod].Value, [usSortStat].Value, Sheets("PivotTable1").PivotTables("PivotTable1"). _
            PivotColumnAxis.PivotLines([drpSortStat].Value), 1
    Application.ScreenUpdating = True
    End Sub
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Error " Run-time error '1004': application defined or object defined error
    By lengwer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2013, 07:26 AM
  2. Receiving following error “Complie error : syntax error” Help
    By masond3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-02-2012, 10:19 AM
  3. Error "run-time Error '1004': General Odbc Error
    By D4WNO77 in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-16-2012, 09:55 AM
  4. Error 75 File/Path access error, sometimes Error 1004
    By smokebreak in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-16-2011, 02:35 PM
  5. Error Handling - On Error GoTo doesn't trap error successfully
    By David in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-16-2006, 02:10 PM

Tags for this Thread

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