Sorting Problems

[bpeirson]

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).

 

[IRstuff]

I'm not seeing that.

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

 

[bpeirson]

I wasn't sorting with the macro, all sorting was done manually.

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.