How is it possible to change the name of a specific existing Chart in EXCEL using VBA?
The code should be
My problem is how can I determine the x (i.e. the Number of the Chart-Object)? Since the code could be used several times the number will change.VB Code:
Charts(x).Name="BlaBla"
To make it easy, the setting of the name could be done wwhen creating the chart (or just after the " Chart.add").
Thanks




Reply With Quote