Hi!

Yes, that's exactly what I have, Sheet1!$A$1:$A$6.

Brgds

Danny

"Tom Ogilvy" wrote in message
...
When you define the name letters do you have

=Sheet1!$A$1:$A$6

as the refers to, including the $

if not, then that might be your problem. You need to use absolute
references.

--
Regards,
Tom Ogilvy


"Daniel Magnus Bennét Björck" wrote in message
...
Hi!

I mean the sheet with the "=Letters" formulas.

I've tried it several times with newly created workbooks, different
values,
selections, and everything, and keep getting the same result.

Others in the same company are also getting incorrect sorting,
especially
under Excel 97.

Brgds

Danny

"Tom Ogilvy" wrote in message
...
When you say sort on A1:A6, on the original sheet or on the sheet with
the
=Letters formula.

In any event, I couldn't reproduce your problem in xl2000.

--
Regards,
Tom Ogilvy

"Daniel Magnus Bennét Björck" wrote in
message
...
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