Hello Everyone,
In the past when I have run into an error, VBA would stop and allow me to debug and it highlights the line where the error is occuring. In this case it does not provide the line of code that is causing the error and therefore I cannot determine what is the causing the error.
I have attached a copy of the workbook with the two subroutines that I know the error is located within uncommented (all other subroutines require access to a separate program), whereas these two only use Excel. The excel solver (not on by default) is used in the Crack Analysis code.
The Crack Initiation button runs through the code once and stops. However, clicking on this button does not provide me with an error. The crack growth button is meant to iterate through by the number in the interations cell by calling Module 1.
The error is returned by the following block of code (which is used to capture errors), but the line of code is not provided for debugging purposes.
Does anyone know how to determine which line of code the Application-defined or object-defined error is occuring?
I would really like to know what could be causing this error only when the iterative button is pressed.
Regards,
Kyle
Bookmarks