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.