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
Bookmarks