What does "but not on another PC" mean?
What happens when you run the code?
Is the sort done incorrectly.
Do you get an error? If so what error?
How is NewSort1 declared?
What is its value?
Does the Selected range encompass the NewSort1 Column?
Is the code installed in the same place and in the same type of module on both machines?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Gleam"
wrote in message
This code works in 2003 but not on another PC with 2000
Selection.Sort Key1:=Range(Cells(13, NewSort1), Cells(13, NewSort1)), _

Order1:=xlAscending, Header:=xlYes, _

OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

Any ideas why not? I do not have access to a PC with 2000 on it.
Other posts mention DataOption2 but this does not appear here.