Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting issue has got me puzzled!
Hi all,
I've tried numerous combinations of selection.sort in my code however none are working. I'm stumped however believe maybe have spotted a possible cause. My code is showing the word SORT in capitals (non defaulting to normal text as expected). I thought this may be because somewhere in my personal wb or the current open wb I had stupidly named a sub SORT however cannot find anything. Please see the code I have tried below, any help would be much appreciated; ActiveSheet.Range("A2:ad" & ro + 1).SORT Key1:=Range("c2") or ActiveSheet.Range("A1:ad" & ro + 1).Select Selection.SORT Key1:=Range("C1"), Order1:=xlDescending, Header:=xlYes, OrderCustom:=1, _ MatchCase:=False, Orientation:=xlTopToBottom The code does not error, just does not sort the selected range. I have looked at sort code in another workbook and that is NOT in capitals. I have checked and there are no macros/modules containing any code in my personal wb, (and I have no other wb's open) also the word SORT does not appear anywhere else in my code (eg. I have not been silly enought to Dim SORT). I'd appreciate it if anyone can spot my (no doubt stupid) error! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting issue has got me puzzled! | Excel Programming | |||
Sorting issue | Excel Programming | |||
puzzled | Excel Worksheet Functions | |||
"... whats this??? am puzzled | Excel Programming | |||
EASY ONE ! using countIF.. puzzled | Excel Discussion (Misc queries) |