Try using the Find method in VBA, where you can take in a specific
information to search for, where you can reference that from your
search range. Use the VBA Help to see how it works.


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=546326