Excel starts sorting from row 210 Why?

B

Bob

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
 
J

Jim Rech

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
 
Top