Sorting Problems
Sorting Problems
(OP)
I have 3 lists of information on a worksheet in Excel. I want to sort each list independantly of the other lists (they are in columns A, B & C). When I select the list in column B and choose Data-->Sort Excel changes my selection to include columns A & C. Excel used to ask if I wanted to sort the adjacent cells but it is no longer asking.
How can I override Excel and force a single column sort.
My data is referenced by a VBA subroutine so if I move the data I will have to rewrite the code, I'd rather not do that.
Any help is appreciated (Excel's built in help has not been helpful).
How can I override Excel and force a single column sort.
My data is referenced by a VBA subroutine so if I move the data I will have to rewrite the code, I'd rather not do that.
Any help is appreciated (Excel's built in help has not been helpful).





RE: Sorting Problems
Sub Macro2()
Selection.Sort Key1:=ActiveCell, Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub
sorts on a single column if that's what's selected
TTFN
RE: Sorting Problems
I found the problem, the workbook was shared. After unsharing the workbook all things returned to normal, or at least what passes for normal in the Excel environment.