i am writing a macro that creates charts. I want to use a user defined chart
type (that I have) but I dont know how to write the code for this. My code is:

Charts.Add
With ActiveChart
..ApplyCustomType(xluserDefined, Standard)
..............
End with

As you may see the third line is wrong. How should you write this? Please
help me!

Freddie,

Try this:

Set ch = Charts.Add
ch.ApplyCustomType ChartType:=xlUserDefined, TypeName:="Mikes"

And replace Mikes with the name of your custom chart.

Mike

"Freddie Mac" wrote:

i am writing a macro that creates charts. I want to use a user defined chart
type (that I have) but I dont know how to write the code for this. My code is:

Charts.Add
With ActiveChart
.ApplyCustomType(xluserDefined, Standard)
.............
End with

As you may see the third line is wrong. How should you write this? Please
help me!