I have recorded a macro to add a new chart sheet but when
running the macro is step mode it fails:

the statements are
Charts.Add
ActiveChart.ChartType = xlSurface

and I get

Runtime error '1004'
method Charttype of object _chart failed...

any ideas - this is bog standard code

regards
Sean