Dear excel users,
Is this syntax correct ? I am getting debugging error second time error comes, however it ignores the error for the first time. I want it to skip all errors not just to stop at second.
I have not used exit sub or on error go to 0 statements.
Is this syntax correct ? I am getting debugging error second time error comes, however it ignores the error for the first time. I want it to skip all errors not just to stop at second.
I have not used exit sub or on error go to 0 statements.
Code:
For var_country = 1 To 4
For var_functions = 1 To 2
Functions(1) = "AP"
Functions(2) = "AR"
country(1) = "NO-"
country(2) = "SE-"
country(3) = "DK-"
country(4) = "PL-"
result = country(var_country) & Functions(var_functions)
On Error GoTo Errorhandler:
'MY CODE HERE
Errorhandler:
Next var_functions
Next var_country
End Sub
Last edited: