You might want to use Exit Sub instead of Stop

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Zurn" wrote in message
...

I can write Stop, insteed of End Sub...then the macro ends completely,
but my VBA editor opens!

Isn't there a possibility to stop a macro without the VBA editor opens?


--
Zurn
------------------------------------------------------------------------
Zurn's Profile:
http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=267249