View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default Macro suffers from premature exiting

One of my macros, which has been working for years, now quits prematurely. It
will consistently quit about the 5th statement in on a activesheet.name command.
It executes the command, but then quits, with no error message. If I step past
this command, it will quit about 5 statements later on a copy command (after
executing it as well).

The project is 3 modules long, and about 1000 statements in each module. I've
exported each module to a .bas file, and reimported them, to hopefully get rid
of any fragmentation. There is no protection on the workbook.

I'm using XL2002 SP3 on Windows XP.

Any suggestions from the gurus?

--
Regards,
Fred