Or simply:
Charts.Add.Name = "My New Chart"
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"PK" wrote in message
...
Got it:
Dim Chrt As Chart
Set Chrt = Charts.Add
With Chrt
.Name = "freddykruger"
End With
"PK" wrote:
I need to create a BLANK chart using VBA and rename it.
I am using Charts.Add
The problem i keep running into is that when i create a new chart, it
increments chart1 then chart2, etc... even if i rename the new chart
I am creating a module to be used in MSAccess to automate excel, so i
will
not have the luxury of knowing what the new chart name will be.
It would be great if i could do something like
VariableNewChartName = Charts.Add
Sheets(VariableNewChartName ).Name = VariableMyNewName
or something like that