Hello,
I have a simple macro trying to autosize legends in a chart. I use "For Each" loops to parse through charts and subsequently legend entries. The flawed section is as follows:
It's failing on
most likely because the Value in the locals shows up as <Application-defined or object-defined error>. I've tried added error handlers but this type of error isn't caught (already checked VBA options). It is specifically a "Run-time error '-2147467259 (800004005)': /nl Method 'Top' of object 'LegendEntry' failed". But I'm assuming that error won't get me any closer.
Any help would be amazing.
Thanks in advance!
Jeff
Bookmarks