I have a simple macro that looks for the values in some named cells (using a separate Worksheet_SelectionChange sub) and then switches on/off a corresponding series in a chart.
As this happens very often, I am looking for a way to simplify the code as much as possible to keep performance acceptable. A sample of the code that does the series switching is below, but the full version includes many more lines still. Any advise greatly appreciated.
Please Login or Register to view this content.
Bookmarks