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("A10:D12000").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:confused: