I've created a macro that looks for links in the series name and value formulas for all the charts on a given sheet. The issue is, that in practice, this macro will be run on sheets that have more than one chart. So I'll need to include the name (read Title since the actual name value excel sees isn't helpful to the general user) in the msg box I through at the end of the macro listing all the locations any such links are found so that they can be removed correctly (yes in all cases links are bad for this workbook).
My code as it stands now is below. I've tried a couple ideas where I currently have "ActiveChart.ChartTitle.Characters.Text", but nothing I've come up with has worked thus far.
(Side note the If statement that ends the macro is what I was using to test any ideas that I had/could find on how to capture the title and won't be in the final version)
Thanks for any help!
Bookmarks