View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt Jensen Matt Jensen is offline
external usenet poster
 
Posts: 113
Default Dynamic Named Range repeat on different worksheet

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