Access copied graph in VBA
I have copy and pasted a graph onto another worksheet:
With ActiveChart
.ChartArea.Copy
End With
Worksheets("Legends").Paste
Dim LegendGraph As Object
LegendGraph = Worksheets("Legends").ChartObjects(Workshe开发者_JAVA百科ets("Legends").ChartObjects.count)
The last line won't work. How do I access the copied graph?
I was able to acces the graph like this:
Worksheets("Legends").ChartObjects(Worksheets("Legends").ChartObjects.count).Chart
精彩评论