This VBA code is new to me...

[Greg the dogsitter]

If Then
If Then

End If '
End '*** What does "end" do, on its own?
End If '

Please see asterisks, above...

[TheTominator]

On its own, End will terminate the VBA application.
(It shouldn't be used this way though. Instead you should use Exit.)

Note that I don't know VBA. I have the book VB/VBA in a Nutshell and that is found under the description of End on page 246.