Thanks all,

Guidance much appreciated.

Paul.

"Stefi" wrote in message
...
Clever!
Regards,
Stefi


"Pete" ezt írta:

Before sorting you could use a blank column and fill this with the
sequence 1,2,3 etc. Include this column in your sort range. Then if the
active cell had been C504, you just need to search for 504 in this
helper column - the column can be deleted when not needed.

Pete