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