Good afternoon,

I am still again working on a deck project, and am very new to VBA. I have a large chart that basically has a YES/NO scenario for 42 graphs. I have labeled all my graphs as Y1 through Y42, and now want to make the graphs and post them in a summary page if the main page says to make the graph. Here is an example of what I have for one graph.


If Sheets("ReportGeneration").Range(J7) = YES Then

Sheets("YoY Summary").ChartObjects("Y1").Activate
ActiveChart.ChartArea.Copy
Sheets("Graphs YoY").Select
Range("B2").Select
ActiveSheet.Paste

End If

The YES/NO goes from cell J7 to J48, and then I have 5 more tables like this. I know if I just try to write this case for each graph I am going to have used too much memory. Any help would be great!!

Thanks,

Charles