Label not defined

[richarddawson]

I am getting this message frequently - a rather simple example is

Sub newSub()
On Error GoTo SRTT
J = 3 / 0
End Sub
SRTT:
Stop
End Sub

I have even reloaded Office 365
Can any one help, please?

 

[Norie]

Why do you have End Sub half way through the code and at the end.

Perhaps you mean Exit Sub?

 

[Kamolga]

Hi,

I believe you can not have two "end sub", you should use "exit sub" when you want to stop it in the middle

 

[richarddawson]

Thank you both so much. Your solutions do, of course, work.

Just a very silly mental block on my part. I have spent over two hours on it. I have used "exit sub" many times in the past.

Richard