Your assuming the ranges/cells move. The formatting and value move, but I
am not sure you can say the cell moves. If you have a formula outside the
sorted range refering to a cell in the sorted range, the formula doesn't
change as a result of the sort.

--
Regards,
Tom Ogilvy

"Gap" wrote in message
oups.com...
Thanks Tom,

I was just wondering if this is the right behavior in Excel. Names are
supposed to be attached to or propertyh of the Ranges both technically
speaking and in business sense.

Regards
Amitabh