View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Carlo Carlo is offline
external usenet poster
 
Posts: 179
Default Charts.add stopped working

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