As long as the sort range has not changed dramatically, Excel should
remember the previous sort used.
Option 1: Instead of using a specific range (A1:C100) you might try
sorting the entire columns (A:C). All of the blank items should go to
the bottom..and as long as you don't have totals, it should work the
same without any extra tweaking.
Option 2: Create a macro to do the specific kind of sort you want.
Then just run your macro every time (I've used that for some sorts I do
just so that I don't have to click "Data-Sort-OK" all of the time).
--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile:
http://www.excelforum.com/member.php...o&userid=28611
View this thread:
http://www.excelforum.com/showthread...hreadid=486243