thank you, this works well.
one thing more. I want to return the cell name next to to cell that
contains specified value.
e.g. if cell B20 contains the value, I want to return next cell name
that is B21.
how can I do this.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=538333