| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with Sort Method After Paste
code ran fine for me.
after the code errors, can you go to Data=Sort and sort the selection manually? -- Regards, Tom Ogilvy "AmytDev" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
