View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jordun
 
Posts: n/a
Default how to do a dynamic ranges?


Hi

create a name containing a formula like this

=OFFSET(reference,rows,cols,height,width)

You can take a look to this post

http://jldexcel.blogspot.com/2006/03...-excel_08.html

in my blog


--
jordun


------------------------------------------------------------------------
jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118
View this thread: http://www.excelforum.com/showthread...hreadid=529775