Whenever I try to use an End Sub in my If statement it wont work why is this and is there any way I can get around it.

Matt