LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exiting Excel MEAD5432 Excel Discussion (Misc queries) 2 December 7th 07 11:05 PM
TextBox_Change a little premature! Post Tenebras Lux Excel Programming 4 September 4th 06 10:03 AM
Exiting Worksheet Evan Excel Discussion (Misc queries) 1 February 11th 05 06:06 PM
Exiting a VBA Macro by user intervention JON Excel Programming 1 April 23rd 04 06:01 PM
Exiting a workbook Dick Kusleika Excel Programming 0 August 15th 03 05:30 PM


All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"