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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
It could be that they are not selecting a range with column C in it. Try adding a dot "." ahead of all three column designations. That way the sort will take place relative to the selection. Column C will then be the third column of the selection (not the worksheet). -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "peyman" wrote in message 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
Jim,
they don't need to select any range.I do select the range then sort and save.when the other users save,they should see all my changes?right? "Jim Cone" wrote: It could be that they are not selecting a range with column C in it. Try adding a dot "." ahead of all three column designations. That way the sort will take place relative to the selection. Column C will then be the third column of the selection (not the worksheet). -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "peyman" wrote in message 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
Sorry, I missed the "shared" part. I have no experience with shared workbooks. So I don't know what will or won't happen. There are an amazing number of limitations with shared workbooks. See... "Features that are unavailable in shared workbooks" in help. My advice still applies, however, no matter the type of workbook. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "peyman" wrote in message Jim, they don't need to select any range.I do select the range then sort and save.when the other users save,they should see all my changes?right? "Jim Cone" wrote: It could be that they are not selecting a range with column C in it. Try adding a dot "." ahead of all three column designations. That way the sort will take place relative to the selection. Column C will then be the third column of the selection (not the worksheet). -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "peyman" wrote in message 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
THANX JIM.I APPLIED YOUR ADVICE.BUT I HAVE STILL THE SAME PROBLEM.
"Jim Cone" wrote: Sorry, I missed the "shared" part. I have no experience with shared workbooks. So I don't know what will or won't happen. There are an amazing number of limitations with shared workbooks. See... "Features that are unavailable in shared workbooks" in help. My advice still applies, however, no matter the type of workbook. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "peyman" wrote in message Jim, they don't need to select any range.I do select the range then sort and save.when the other users save,they should see all my changes?right? "Jim Cone" wrote: It could be that they are not selecting a range with column C in it. Try adding a dot "." ahead of all three column designations. That way the sort will take place relative to the selection. Column C will then be the third column of the selection (not the worksheet). -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "peyman" wrote in message 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. |
Reply |
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) |