Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba sorting stopped working
I have been using the following code for several weeks, and it has worked
fine. All of a sudden, it is not sorting anymore. Any ideas what nuances I need to check to verify are still in place? I don't recall messing with any of this. Range("y:AC").Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Set pareto = table.Resize(fields, 5) pareto.Select Application.CutCopyMode = False pareto.Sort Key1:=Range("AA2"), Order1:=xlDescending, Key2:=Range( _ "AC2"), Order2:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase _ :=False, Orientation:=xlTopToBottom ', DataOption1:=xlSortNormal, _ DataOption2:=xlSortNormal 'x1SortNormal is default TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help in Excel stopped working | Excel Discussion (Misc queries) | |||
Charts.add stopped working | Charts and Charting in Excel | |||
Web query has stopped working... | Excel Discussion (Misc queries) | |||
VB Stopped Working | Excel Worksheet Functions | |||
Tab stopped working | Excel Programming |