Thread: Dynamically set a range?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BKGT
 
Posts: n/a
Default Dynamically set a range?

Is there a way to dynamically set a range? For instance... can I have a
formula that includes a range (Ax:Ay) where I can set the values of x
and y based on the value of another cell so that in one case, the range
may be A1:A80 and in another it may be A50:A60 and so on?

Thanks.


--
BKGT
------------------------------------------------------------------------
BKGT's Profile: http://www.excelforum.com/member.php...o&userid=33862
View this thread: http://www.excelforum.com/showthread...hreadid=536778

Reply With QuoteReply With Quote