I had a set of VBA code written against Excel 2003. It worked flawlessly until bringing it into 2007.
I'm sure that the full set of VBA could be written better as I'm just starting my VBA journey, but that is besides the point.
Now after re-creating the VBA code in an *.xlsm Excel 2007 file, this one section isn't working.
As I step through the VBA code, everything works up until this point.
Where it is failing is that the VBA Script is not updating the Chart title to reference the worksheet called "Hidden - Chart Titles" and choosing the text in the incremented row in the 2nd column. There is a default chart title on the sheet as that worksheet is being copied in, and I want it to set the text.
Hope that makes sense to someone far smarter than me.
Thank you in advance for any help that you may be able to provide.