Can you write to a worksheet cell when VBA captures an error?

  • I have some error handling code below. As soon as you seem to try and put anything in the error handling section, other than an error message, it seems to jump out of the error handler and exit the sub as though the sheets code is in error itself.

    I am trying to capture the error so I can manually iterate one aspect of the formula because if there is an error it should go to the next. Without the error handling excel jumps out of the code and an incorrect solution is found with no warning.

    Any suggestions appreciated!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!