Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a Dynamic Named Range in VBA
Hi All,
I'm trying to set a chart (it's a Gantt chart I've built so the data series' are quite complicated) so that it automatically expands to however many tasks there are (between 1-25). Is there a way to write a macro that changes the source data for 5 different data series to expand/contract to the number of tasks. I've tried to use dynamic named ranges and dynamic charts, but just can't get the results I need (I'm a VBA alter-er, I can usually adapt stuff I find online to my needs...but haven't been able to tweak this correctly yet). Please help! -David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a Dynamic Named Range in VBA
http://tinyurl.com/yqfytw
Might give you some ideas -- Regards, Tom Ogilvy wrote in message ups.com... Hi All, I'm trying to set a chart (it's a Gantt chart I've built so the data series' are quite complicated) so that it automatically expands to however many tasks there are (between 1-25). Is there a way to write a macro that changes the source data for 5 different data series to expand/contract to the number of tasks. I've tried to use dynamic named ranges and dynamic charts, but just can't get the results I need (I'm a VBA alter-er, I can usually adapt stuff I find online to my needs...but haven't been able to tweak this correctly yet). Please help! -David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a named range on another sheet | Excel Worksheet Functions | |||
referencing a 3D Named Range | Excel Worksheet Functions | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
referencing a named range using a variable | Excel Programming | |||
Referencing Named Range in Other Sheet | Excel Programming |