Quitting a macro after error is detected?

[hans302]

Hi - I have the following VBA and need to add some code at the end of the line to Quit the Macro after “err.Clear” at present it proceeds to the next lines until the end.

Can anyone help?

Please Login or Register  to view this content.

Ta

Hans

[AB33]

Do you mean like

Please Login or Register  to view this content.

?

[kev_]

Please Login or Register  to view this content.

[Jan Mach]

If you want to quit the subroutine after error, write the line like this:

Please Login or Register  to view this content.

or longer but possibly easier to read:

Please Login or Register  to view this content.

There's no need of Err.Clear; the Err object is cleared automatically when the subroutine terminates and that's what the 'Exit Sub' command does.