Simplification of code for Chart Series control

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.

you need to look for patterns to get the best efficiency. so, one that I can see right away in your code is this:

Please Login or Register  to view this content.

do you see it? you are looking at sequential ranges. thus, you could reduce stuff like this and write it in a loop like this:

Please Login or Register  to view this content.

now, that code might not be absolutely perfect because I didn't test it. however, more than likely you can do it.

Well guys do you think it is failing on the line because the variable called ""n"" is not defined and you are using it as an index number of the collection? That's what it looks like to me

Hahaha I got you there rorya! Lol. Hey it's always a pleasure to engage with you Excel professionals. :-)

Chaps - what else can I say but thank you! This works perfectly. Im sure I will make use of this type of method again, so I appreciate the knowledge.

From question to full working solution in a little over an hour, such a helpful resource this place is!