Results 1 to 1 of 1

Thread: Excel AutoSort Error - RESOLVED

  1. Jul 6th, 2004, 10:44 AM #1
    Helene
    Helene is offline

    Thread Starter
    New Member
    Join Date
    Jul 2004
    Location
    New York
    Posts
    15

    Excel AutoSort Error - RESOLVED

    Good morning all. Hope you enjoyed your holiday.

    I am trying to add autosort to an existing control button.
    The following is what I have:

    Sheets("Run ").Range("A1012000").Select
    Selection.sort Key1:=Range("A10"), Order1:=x1Ascending, Key2:=Range("C10"), Order2:=x1Ascending, Header:=x1Yes, OrderCustom:=1, MatchCase:=False,Orientation:=x1TopToBottom

    This produces RunTimeError 1004
    Sort method of Range Class Failed.

    Also is telling me - The sort reference is not valid. Make sure that it's within the data you want to sort, and the first sort by box isn't the same or blank.

    Any sugguestions would be greatly appreciated.
    Thanks for your help.

    -Helene
    Last edited by Helene; Jul 6th, 2004 at 02:20 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width