View Single Post
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default 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