| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto insert worksheet name in dynamic named range
Hello,
I've heard of dynamic named ranges but is there something to automatically insert the name of a newly added worksheet in the named range? My excel file has 200 worksheets and is expanding. I've created a dynamic name range to use as a reference to my drop down menu for easy access to the worksheets. But I'm tired of manually adding the newly created worksheet name to my dynamic list. Please let me know if this is possible. Thanks for looking, MJ -- Thank You! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
auto insert worksheet name in dynamic named range
Maybe you could just add another feature to refresh the list of worksheet names
in that range. maijiuli wrote: Hello, I've heard of dynamic named ranges but is there something to automatically insert the name of a newly added worksheet in the named range? My excel file has 200 worksheets and is expanding. I've created a dynamic name range to use as a reference to my drop down menu for easy access to the worksheets. But I'm tired of manually adding the newly created worksheet name to my dynamic list. Please let me know if this is possible. Thanks for looking, MJ -- Thank You! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
auto insert worksheet name in dynamic named range
How can I do this sir? Is this a timer thing or an automatic refresh on open
thing? Or can I make a button to execute this kind of function? Please let me know by example or if you have a website I can train myself on. Thank you very much, MJ -- Thank You! "Dave Peterson" wrote: Maybe you could just add another feature to refresh the list of worksheet names in that range. maijiuli wrote: Hello, I've heard of dynamic named ranges but is there something to automatically insert the name of a newly added worksheet in the named range? My excel file has 200 worksheets and is expanding. I've created a dynamic name range to use as a reference to my drop down menu for easy access to the worksheets. But I'm tired of manually adding the newly created worksheet name to my dynamic list. Please let me know if this is possible. Thanks for looking, MJ -- Thank You! -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
auto insert worksheet name in dynamic named range
Check your other post for a way.
maijiuli wrote: How can I do this sir? Is this a timer thing or an automatic refresh on open thing? Or can I make a button to execute this kind of function? Please let me know by example or if you have a website I can train myself on. Thank you very much, MJ -- Thank You! "Dave Peterson" wrote: Maybe you could just add another feature to refresh the list of worksheet names in that range. maijiuli wrote: Hello, I've heard of dynamic named ranges but is there something to automatically insert the name of a newly added worksheet in the named range? My excel file has 200 worksheets and is expanding. I've created a dynamic name range to use as a reference to my drop down menu for easy access to the worksheets. But I'm tired of manually adding the newly created worksheet name to my dynamic list. Please let me know if this is possible. Thanks for looking, MJ -- Thank You! -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dynamic named range | New Users to Excel | |||
| Dynamic Named Range | Charts and Charting in Excel | |||
| getting the absolute range address from a dynamic named range | Excel Programming | |||
| paste values from named dynamic range to another worksheet | Excel Programming | |||
| Dynamic Named Range repeat on different worksheet | Excel Programming | |||
Hybrid Mode
