Changing Chart Titles then looping to change on every sheet

[jrembold]

I have come up with a rudimentary macro that changes the title of a chart to whatever is in cell F2
Every sheet in the workbook is set up so that the name of the chart should be whatever is in F2
however, the macro only works on the active sheet. here it is

Please Login or Register  to view this content.

I want it to do this task but on every sheet without me manually going through and entering the keyboard shortcut on every sheet. thanks all!

[fshbet]

Hi jrembold,

Just Try this code. This will loop through all the sheets and change the title to Activesheet Range of F2

Please Login or Register  to view this content.

[jrembold]

Thanks for the help Fshbet.
I tried it and the debug came back as saying "Run time error '1004' -- Application defined or object defined error" and had the

With Sheets(i).ChartObjects(1).Chart

line highlighted.

any thoughts?
thanks again

[fshbet]

Hi jrembold,

just change the code to this,

the error because some sheets doesn't have charts so only that error.

Please Login or Register  to view this content.

[jrembold]

thanks again! would you have any idea how to successfully combine this macro with looping in with a large handful of other macros so that we can have each individual macro do its job on one sheet then cycle through all the sheets and do the job with one shortcut?

[fshbet]

Hi, jrembold,

ya if u want just attach the sheet so that i can combine all the macro.