This has to be easy.

[PK]

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

 

[PK]

Got it:

Dim Chrt As Chart

Set Chrt = Charts.Add
With Chrt
.Name = "freddykruger"
End With

 

[Jon Peltier]

Or simply:

Charts.Add.Name = "My New Chart"

- Jon