ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Dynamic Named Range repeat on different worksheet (https://www.excelbanter.com/excel-programming/319046-dynamic-named-range-repeat-different-worksheet.html)

Matt Jensen

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



Matt Jensen

Dynamic Named Range repeat on different worksheet
 
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






All times are GMT +1. The time now is 03:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com