Re: $$Excel-Macros$$ Vba find order in which a range of dates are stored

To compare two dates, use the DateDiff() function. Something like:Sub ChkSort()     Dim nRow     For nRow = 1 To 10     Select Case DateDiff("d", Cells(nRow, "A").Value, Cells(nRow + 1, "A").Value)     Case Is > 0     MsgBox "Sort is Ascending"     Exit For

$$Excel-Macros$$ Vba find order in which a range of dates are stored

Range A:A contains a set of dates Rane B:B contains a set of dated Both ranges have been sorted asc or desc. Unknown which. Need a method to find the order in which dates are stored in each range. Thanks for any suggestions. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna