Thanks for the quick reply. When I make the change you suggest, I am
*always* given the value in the first row of the range. What I want is
to get the *corresponding* A column cell. So, if the 'C' is in row 23,
give me A23.


--
sunfish62
------------------------------------------------------------------------
sunfish62's Profile: http://www.excelforum.com/member.php...o&userid=24541
View this thread: http://www.excelforum.com/showthread...hreadid=381356