how to sort date in descending order by row?

[xq]

i know there is a sort in ascending order by row, but i don't know what about descending, do i have to create the sort by my one or that is a easy way to go?
thanks a lot!

 

[Loomah]

Hi, xq
If you're doing this by code simply change the constant for Order1 to xlDescending

eg
Sub sort()
[a1].CurrentRegion.sort Key1:=Range("A1&quot, Order1:=xlDescending
End Sub

Without code, for a single colummn example, select a cell and click the 'Sort Descending' button or choose Data>Sort and select your options as appropriate.
;-) If a man says something and there are no women there to hear him, is he still wrong?
"...Three Lions On A Shirt..."

 

[xq]

thank u!