PC Review


Reply
Thread Tools Rate Thread

breakpoint affecting the run speed of a macro

 
 
kebabb
Guest
Posts: n/a
 
      1st Dec 2006
Hi,

I have a macro that seems to be running slowly when left to its own
devices. I did some testing to figure out which particular part of the
macro was being slow (a part that loops through an array and writes
data to a worksheet). If I put a breakpoint immediately before the slow
part then hit F5 to continue execution, it runs much faster (2 secs
versus 30 secs without the breakpoint). This makes no sense to me. Can
someone please explain what precisely is happening here?

Thanks!

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Range Name affecting speed of macro Richard Buttrey Microsoft Excel Programming 6 1st May 2006 03:06 PM
Range Name affecting speed of macro Richard Buttrey Microsoft Excel Worksheet Functions 5 1st May 2006 03:06 PM
sumproduct, arrays affecting speed =?Utf-8?B?RGF2ZSBCcmVpdGVuYmFjaA==?= Microsoft Excel Worksheet Functions 4 1st Dec 2005 11:16 PM
Win 2000 sp4 affecting cable modem speed Mike Microsoft Windows 2000 5 7th Mar 2004 08:23 AM
Network connection affecting speed of computer =?Utf-8?B?VHVycmljYW4=?= Windows XP Help 0 23rd Jan 2004 05:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:11 PM.