sorting a column with dates

[kragster]

Hi,
I am making a macro in excel to sort a column by dates. The dates have the following format dd/mm/yy. This is the code I use:

Sub SortByBestilt()
    Range("B10:O65536").Select
'Header to sort after    
Selection.Sort Key1:=Range("H10"), Order1:=xlAscending, Header:=xlNo, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortDate
End Sub

Problem is it sorts the dates as numbers not dates. Can anyone help me out here?

 

[kragster]

Woops. This is the code

Sub SortByBestilt()

    Range("B10:O65536").Select
    Selection.Sort Key1:=Range("H10"), Order1:=xlAscending, Header:=xlNo, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal
    Range("B10").Select
          
End Sub

 

[SkipVought]

hi,

"Problem is it sorts the dates as numbers not dates"

REAL Dates are NUMBERS and that's EXACTLY how they sort.

Why do Dates and Times seem to be so much trouble? faq68-5827

Skip,

_[red][/red]