View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default How to Kill a vba macro from a Function//

That also clears any persistent variables (public/static).

You may want to use this very sparingly (or not at all).

bhofsetz wrote:

Coco,
Just use

End

that will End the function and the macro which called it.

HTH

--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=381767


--

Dave Peterson