Claude,

Sorting effectively copies cells, not moves cells, something most apparent
when you have formulas in the table that's been sorted, but also with range
names -- they stay put. Perhaps you can use a name column instead of range
names.
--
Earl Kiosterud
www.smokeylake.com

"Claude38" wrote in message
...
Hello,

I have an array of cells containing questions and answers. I want to
present those question in a different order every time. So I generate a
list
of random numbers associated with the question-answer duets and I use
those
numbers to change the order when I need to. But for future processing,
each
answer cell has a name, and the name stays in its original place after
sorting, which seems strange to me.

Is there a way around this problem ?

Thanks for helping.
Claude