Is there a way of devining a range to be sorted without dragging the mouse over it in the first instance. I am trying to do this in a macro but whenever I go to sort it elects the range automatically and when I hit escape to get out of it, it exits the sort procedure completely.

When you say that you want to devine a range do you mean like this:

1. Get the formula to go to a specific cell or range (ie. A1 or A1:F1)
2. then find where the information in that column ends (ie. go down the column(s) until you encouter a blank cell)
3. then pass this range to the next part of your script (ie. A1:A254 or A1:F254)?