Handling error in VBA

Hello everyone

When I am using this line [On Error GoTo ErrHandler] to navigate to a specific point

ErrHandler:
            If Err Then On Error GoTo 0: Err.Clear: Debug.Print sFileName
            sFileName = Dir

I can move into the point just once but if the error occurs again, I got an error and the code stops. How can I make the code moves the point `ErrHandler` every time the error occurs?

The question posted here too
https://eileenslounge.com/viewtopic.php?f=30&t=39437