Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 97 generating email automatically starts Lotus 6. DefaultOK | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Sorting data in Excel.. | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |