Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
hi,
I've a macro for sorting a selected range in a worksheet.the workbook is shared.the problem is when I sort it in my file, the macro works well but for the other users the range is not sorted?! Sub Rectangle1954_Click() Dim myRng As Range Set myRng = Selection.Areas(1) With myRng .Sort key1:=Columns("C"), order1:=xlAscending, DataOption1:=xlSortNormal,_ key2:=Columns("B"), order2:=xlAscending, DataOption2:=xlSortTextAsNumbers,_ Key3:=Columns("F"), order3:=xlAscending, DataOption3:=xlSortNormal End With End Sub any help? thank you for your time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting | Excel Discussion (Misc queries) | |||
Sorting | Excel Worksheet Functions | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Help with sorting.. | Excel Discussion (Misc queries) |