View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
aca[_14_] aca[_14_] is offline
external usenet poster
 
Posts: 1
Default Defining Range with Relative R[1]C[1] notation


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