Thread: sort date/time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
srroduin srroduin is offline
external usenet poster
 
Posts: 34
Default sort date/time

I have the following code which worked great when I was sorting only
dates....but it won't sort if I have date and time, 04/02/2006 11:00 format.
What do I have to do differently?

Selection.Sort Key1:=Range("B10"), key2:=Range("N10"), Order1:=xlAscending,
Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal