I have the following code in my excel workbook that is used to pull in a chart when running a report:
The code works great Most of the time, but occasionally fails at the line Highlighted in the attached file. In order to proceed, all I have to do is click inside the VB code window on Run, then choose to Continue (F5) and the code proceeds without more errors and displays the report with the charts.
The Error message is Run-time error '2137221040 (800401d0), The specified dimension is not valid for the current chart type. I have researched these errors, but have not found a solution
I have been looking for a way to capture this error and then force it to continue, but all I see is ways to capture and then force 'Next' which skips the line of code where the error occurs. I do not want to do that.
If anyone knows of a way to 'Continue' in vba on error, or any other suggests, it would be greatly appreciated. Perhaps I am not understanding the error code procedure correctly.... Help Please!
Bookmarks