I think this article:
http://msdn.microsoft.com/library/de..._chap05idx.asp
has everything I will need to answer this question.
Matt

"Matt Jensen" wrote in message
...
Howdy
I've got a dynamic named range (usually 4 columns x 50 rows) created using
the offset formula and some other named cells for variables, and ideally
want to show the resultant range on another worksheet, including allowing
the repeat of the range to expand (or contract) vertically and
horizontally.

I'm not sure what this is called, maybe if I knew this I could figure it
out...
Any help greatly appreciated.
Cheers
Matt