Hello guys, ive been trying to do some error management with on error go to ErrorList.
My error list looks like this:
ErrorList:
If Err.Number = 9 Then
MsgBox ("Unable to find data, confirm if sheet: " + populatingArray(i, 4) + " is open")
End If
Error 9 is: Subscript out of range
So every time this error pops up, id like to inform the user that the sheet is not open, and to give him a choice to either: close the macro, open the sheet that was missing and retry running.
Since there's a long process that comes beforehand i don't want to restart the whole sub and id like the code to return to the initial position before the error was encountered and try to run again with the correct sheet open, how do i do that?
My error list looks like this:
ErrorList:
If Err.Number = 9 Then
MsgBox ("Unable to find data, confirm if sheet: " + populatingArray(i, 4) + " is open")
End If
Error 9 is: Subscript out of range
So every time this error pops up, id like to inform the user that the sheet is not open, and to give him a choice to either: close the macro, open the sheet that was missing and retry running.
Since there's a long process that comes beforehand i don't want to restart the whole sub and id like the code to return to the initial position before the error was encountered and try to run again with the correct sheet open, how do i do that?