Question
Is it possible to have multiple 'On Error GoTo' statements within a single VBA procedure?
Asked by: USER8142
89 Viewed
89 Answers
Answer (89)
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.