Sort all rows with data except for first row

[babbeleme1]

Hey All,

I want to write a macro that will sort my worksheet called "90Day" according to the dates in Column I. The number of rows in the sheet will always change, but I want to essentially sort all of the rows with data, EXCEPT for the first row.

How would I do this?

Thanks in advance!

[xladept]

Try this:

Cells.Sort Key1:=Range("I1"), Order1:=xlAscending, Header:=xlYes

[Sbarro79]

xladept was quicker

[babbeleme1]

I extracted parts and pieces of what you gave me, and managed to make it work, so thank you for your help!!

[xladept]

You're welcome! There weren't many "parts or pieces" - glad you got it working