Thread: Sort works in 2003 but not in 2000
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gleam Gleam is offline
external usenet poster
  
Posts: 87
Default Sort works in 2003 but not in 2000
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.
Reply With QuoteReply With Quote