Hi!

I have a sheet all with Named Ranges in it which behaves strangely when
sorting (Excel 2000).

I get the same result if creating a new fresh file to test. For instance:
1) Create a sheet with the letters A, B, C, D, E, F in column A, rows 1-6
2) Name A1:A6 "Letters"
3) Create a second sheet, and put the formula "=Letters" in A1:A6
4) Select A1:A6 and sort on it ascending - fine
5) Now sort on it descending - and it comes out A, E, D, C, B, F ?!

I've also noticed that if you repeat sorting enough times, adjacent columns
will become out of sync.

Anyone have any idea why this is happening and what the workaround is?

Brgds

Danny