Have a look in help index for OFFSET and
It might be best to define a name for the range to sort
insertnamesdefinename it anything you desire (sortrange)in the refers to
box
=offset($a$2,0,0,counta($a:$a),6)


--
Don Guillett
SalesAid Software

"cHris" wrote in message
...
How do I set a default data sort on a selected range in Exel. I select
from
the collumn that the data need to be sorted on. But I have to select
decending all the time and select no header row all the time. All I want
to
do is select the range to sort and hit OK.