Charts and Macros

[Darren Donegan]

Help! I have recorded a macro to create a chart. When I run it I get the error message "Compile Error : Expected function or Variable". This occurs with the first line of code, which is "Charts.add"

Any thoughts?

 

[philR]

try just adding "application", ie.

Application.Charts.Add

 

[Darren Donegan]

Thanks