Hi

I want to have a specified range appear in a form, sorted by one row in
the range.

Like this on the sheet:

x b a 3
b a x 1
b b a 2

....and like this on the form (sorted by the last row):

b a x 1
b b a 2
x b a 3

Is this possible?

Hi Cel,
I believe you meant sorted on the last *column*,
and according to the title in the worksheet instead of a User Form.

select the entire range to be involved, usually
you just select the entire sheet ctrl+A

You can do it this way,
select any cell in in Column D, then Ctrl+A
then Data, Sort, column D ascending, no headers
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Cel" wrote in message om...
Hi

I want to have a specified range appear in a form, sorted by one row in
the range.

Like this on the sheet:

x b a 3
b a x 1
b b a 2

...and like this on the form (sorted by the last row):

b a x 1
b b a 2
x b a 3

Is this possible?