I have an Excel macro where I am selecting a worksheet in a workbook, and if the worksheet does not exist, it is supposed to go to the next one. I am doing this by using the On Error statement.

I have this statement in the begining of the sub.

Code:
On Error GoTo OverHere
Then I have the following further down in the code.
Code:
OverHere:
It seems to only work for the first error, but doesn't catch any after that. The code stops running and a debug message box pops up.

Does anyone know why it is only catching the first instance of the error?