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: 553
Default Testing for Slow Routine

I have a routine which is really slow. Gets slower as it runs. I am trying
to pin down the cause of it. I have a status bar which illustrates how it
slows down. Note the status bar itself can be part of the issue. Are there
any tests I can perform within the code to test for memory usage? I am
simply looping through sheet and cells and extracting data and printing to a
summary sheet(Using Set statement to create location for each paste). I am
looking for a way to prove to myself that something is eating up memory.

Thanks.
 
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
sub routine Gord Dibben Excel Discussion (Misc queries) 0 November 13th 09 12:15 AM
Slow Excel Navigation with Up / Down Arrow and slow scrolling deddog Excel Discussion (Misc queries) 0 August 14th 07 09:56 PM
Routine running slow (memory leak?) ExcelMonkey Excel Programming 3 February 1st 06 11:20 AM
Too slow testing Liedson31 Excel Programming 2 June 3rd 05 04:36 PM
Slow FileSearch Routine stratuser Excel Programming 0 May 14th 04 02:56 PM


All times are GMT +1. The time now is 08:22 AM.

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"