What do you actually want to sort, without that information you
are only going to get some speculation.. What is not to be included.
In most cases using Ctrl+A to select all cells (all rows, all columns)
usually works. But it looks like your data begins in Row 8 so if you
have 7 headers rows for instance you would have to choose your
area as you can only tell the sort that the data has a header row or not.
You could select A8:IV65536 but the question is there stuff you
want in the first 7 rows. Since the Sort is builtin
there will not be an adverse effect that you selected too much.
If you were to overselect and simply process every single cell in
your own macro without regard to used area, or cells with content
that would be another matter..
There are some shortcuts that you might want to look into.
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
specifically those that extend a selection.
CTRL+SHIFT+* (asterisk)
Select the current region around the active cell (the current region is a
data area enclosed by blank rows and blank columns)
This is what SORT uses when you start with a single cell selected.
END, SHIFT+arrow key
Extend the selection to the last nonblank cell in the same column or row as the active cell
CTRL + SHIFT + END
Extend the selection to the last used cell on the worksheet (lower-right corner)
BTW the range you gave is the range A8:J500 since it is a single
range A8 in the upper left corner and J500 in the lower right corner.
