Hi All,
I am working on a Dashboard that charts trend data dynamically.
The user can choose any 'Areas' or 'Systems' from lists, and the 'Meters' that belong to any selected 'Areas' and 'Systems' are listed.
To add this functionality, the code iterates through all possible Meters (24), checks them against both lists, then populates the cell range.
After the list of Meters is populated, a module routine runs to update the chart dynamically.
The code is working, but is very slow to update. Any tips on cleaning it up at bit?
Specifically: When I added the routine that updates the 'ChartSourceN' named ranges, things really slowed down.
Any help is very much appreciated!
Bookmarks