Hi Larry, Usual cause of that behaviour is other event macros.
Start with: Application.EnableEvents = False Then your code. Then at the end: Application.EnableEvents = True Regards - Dave. > Date: Wed, 1 Jul 2009 10:22:49 -0700 > Subject: $$Excel-Macros$$ Stop with output subroutine > From: laurence.tha...@navy.mil > To: excel-macros@googlegroups.com > > > I am working on a macro where I would like the program to run the main > subroutine and then run the output subroutine once and end the > program. Instead, it appears to be returning to the main program and > doing more calculations and coming back to the output again. Any ideas > on what I am missing? I tried Stop but that halted all calculations > and got no output at all. > > > _________________________________________________________________ View photos of singles in your area Click Here http://dating.ninemsn.com.au/search/search.aspx?exec=go&tp=q&gc=2&tr=1&lage=18&uage=55&cl=14&sl=0&dist=50&po=1&do=2&trackingid=1046138&r2s=1&_t=773166090&_r=WLM_EndText --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
