Hi Paul,

See
http://www.mvps.org/dmcritchie/excel...g.htm#activate
copy both macros as indicated change the G2 and E2
to the columns you are sorting on. It will leave the first
row and the last row alone the last row is determined
by going up from the bottom and looking for content

Worksheet will be sorted whenever the sheet is activated
or whenever you double click.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Paul" wrote in message ...
Besides selecting the row and cells, is there a way to prevent a row from
being included in a sort? When using the sort feature it will select all
cells; however, my last row contains totals and I don't want this sorted.
Thanks