Excel starts sorting from row 210 Why?
 

No hidden rows or columns, no named ranges, no print areas, no frozen
rows/columns, but sort acts as if there are 209 header rows (after select
all, data, sort). OK if the precise full data range is selected

Excel starts sorting from row 210 Why?
 

I'm guessing this is because the name "database" has been assigned to a
range. This is usually a hidden name so it would not appear in the Define
Name dialog.

To delete it, open the VBE (Alt-F11) and the Immediate window (Ctrl-g),
paste this in and press Enter:

Names("database").Delete

--
Jim
"Bob" wrote in message
...
| No hidden rows or columns, no named ranges, no print areas, no frozen
| rows/columns, but sort acts as if there are 209 header rows (after select
| all, data, sort). OK if the precise full data range is selected