Thank you, Bob, for a quick reply.
Your line works all right. But I would like to avoid using Offse
because I want my ActiveCell to remain the same one (C4), as this lin
is part of a search down column C which must go on, and it would tak
longer if the Active cell hast to shift to column A at each find an
then back to C to continue the search.
Cannot I select A5:F5 while staying at C4 as my Active cell?
But, hanks again.
AC
--
ac
-----------------------------------------------------------------------
aca's Profile:
http://www.excelforum.com/member.php...fo&userid=2593
View this thread:
http://www.excelforum.com/showthread.php?threadid=54624