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.

Testing for Slow Routine
 

Post your code

--
Kind regards,

Niek Otten

"ExcelMonkey" wrote in message
...
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.

Testing for Slow Routine
 

Hi ExcelMonkey,

See Charles Williams's DecisionModels site:

http://www.decisionmodels.com/optspeedd.htm


---
Regards,
Norman



"ExcelMonkey" wrote in message
...
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.

Testing for Slow Routine
 

The code is too extensive to post as it is a full XLA with an extensive
userform. I could send you the xla itself.

EM

"Niek Otten" wrote:

Post your code

--
Kind regards,

Niek Otten

"ExcelMonkey" wrote in message
...
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.