Charts.Add - Run-time error 1004 pls help
 

I get the above runtime error when I try to run an excel macro to add a chart.

I have read the article stating the reason for the problem:
http://support.microsoft.com/default...b;en-us;179679

But...

The excel workbook I am working with has more than 10 sheets. Though the
type of font used in the workbook is the same, the font size, bold, italic,
font size and cell fromat varies. I am able to create charts manually in the
excel sheet without deselecting the autoscale property of the chart object. .
When it is possible to create chart manually, then in my opinion, the upper
limit for has not been reached yet. I need to create a lot of charts in my
workbook using macros.

Is there a work around to this problem? Is there a method to check if I have
reached the upper limit of 255 fonts?

TIA,
vbaprog