Q: How can I identify if the chart exists in a worksheet The code I am running opens up a workbook and copies a chart from it and pastes it into a PowerPoint slide. Following this, it will open up another workbook of apparently identical format, copy a chart and similarly paste it into PowerPoint. 
The issue: The first graph is successfully copied and pasted into PowerPoint, however when I open up the second workbook and set it to the active workbook there is an issue with running the following code: 
ActiveWorkbook.Charts("Chart1").ChartArea.Copy

I get the error: 
Run-time error '9':
Subscript out of range. 
I have checked the opened workbook and there is a graph within it. I think the issue may be that the graph in the second workbook may not be named "Chart1" however I am not sure how to find this out. 
