Okay...so can anyone help me with debugging my code.

I have a macro that generates charts on separate sheets and titles them according to the column name...however, i want the sheets (the little tabs) that are made with the charts on them to have labels that match the title of the chart.

this is what I have...there seems to be an error.

ActiveChart.Name = DataSheet.Cells(1, icolumn)


any assistance would be greatly appreciated. thanks guys! :)

have you fixed this?

have you tried naming the sheet instead of attempting to name the chart

          worksheets("sheet1").ChartObjects(1).chart.name="b lah"
will give an error b/c chart.name is (almost) readonly in that
the .Name is derived from the SHEET name and the CHART name
i.e.
        debug.print worksheets("sheet1").ChartObjects(1).chart.name
will return
        Sheet1 Chart 2


          sheet1.Name="frog"
this will rename sheet1 to 'frog' just be sure to name the correct sheet. ActiveSheet.Name might work.



hth