Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Sort Method After Paste
Can anyone find out what is wrong with this code? I can't figure out why I
get error 1004 Sort Method of Range Class Failed when I click the custom command button. Sub Sort() Range("B73:D85").Select Selection.Copy ActiveWindow.SmallScroll Down:=17 Range("B91:D103").Select ActiveSheet.Paste Link:=True Application.CutCopyMode = False Range("B91:D103").Select Selection.Sort Key1:=Range("B91"), Order1:=xlDescending, Header:=xlGuess _ , OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you change the default paste method? (paste values) | Excel Discussion (Misc queries) | |||
Paste Method failed (Activesheet.Paste) | Excel Programming | |||
Help with Sort Method | Excel Programming | |||
Cut and Paste using Macro gives paste special method error | Excel Programming | |||
Sort Method | Excel Programming |