How to automatically sort all rows under row 1 according to column A (which has dates)

[ks100]

What script would I use to sort the entire worksheet for row 2 to the last used row, by column A, which has dates?

I want it sorted so that the oldest dates are first.

Thanks!

[Mumps1]

Have you tried recording a macro for this action?

[ks100]

No as I did not know hot to tell the macro to always go to the last row, it does not seem to be a recordable task.

[Mumps1]

Try:

Please Login or Register  to view this content.

Note the variable for the last row.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[winmaxservices]

John, Wow...
What a simple code.

can you please suggest a code to sort entire sheet with 2 columns.

instead of only range a2 i need to sort first G2 and E2 at the same time. please

[JOHN H. DAVIS]

@ winmaxservices - I would be glad to help out. However you should start another thread. See rule No. 2 in the link below.

http://www.excelforum.com/forum-rule...rum-rules.html