Charts.add stopped working

[Carlo]

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

 

[Andy Pope]

Hi,

What do the cells A1:B3 contain?

Cheers
Andy

 

[Jon Peltier]

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

 

[Carlo]

Hi Andy

just found out, that someone protected the workbook instead of the
worksheets, now everything works fine.

Thanks anyways, appreciate the help very much.

Kind regards

Carlo

 

[Carlo]

Hi Andy

Column A contains the Titles
Column B contains Numbers
like

A B
abc 60%
def 30%
ghi 10%

As said, if the chart is created manually everything works fine!

Thanks for the reply

Carlo