Is it possible to have multiple 'On Error GoTo' statements within a single VBA procedure?

Responsive Ad Header

Question

Grade: Education Subject: Support
Is it possible to have multiple 'On Error GoTo' statements within a single VBA procedure?
Asked by:
89 Viewed 89 Answers

Answer (89)

Best Answer
(328)
Yes, it is possible. You can strategically place different 'On Error GoTo' statements at various points in your procedure to handle specific potential errors in different sections of your code. Each 'On Error GoTo' statement will remain active until another 'On Error' statement overrides it or 'On Error GoTo 0' is encountered.