Which line fails? If you created a chart sheet and it is still active, the
Range.Select line will fail with an RTE 1004.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Carlo" wrote in message
...
Hi all

I programmed an application which adds a chart to a sheet with a simple:

Range("A1:B3").Select
Charts.Add

But now excel gives me a Runtime Error 1004 while creating the chart.

However, if I set up a chart manually and record the macro it does the
exact same thing. if I run the macro afterwards, I still get the 1004!

Any suggestions are welcome

Thanks in advance

Carlo