![]() |
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 |
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