That's good...as long as your code is not using the contents of the
worksheet(s) for further analysis.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hey Harald Staff Thanks for the help, I've tried turning off the calculation
and that has knocked off about half the time of the code but where I find the
place to trun off Events ?

"Harald Staff" wrote:

That depends on what Certain things are. Turning off Calculation, Events and
Screen updating usually helps. But bad structured code may run for minutes
anyway, so may database queries to Oracle and things like that.

HTH. Best wishes Harald

"Jason Zischke" skrev i melding
...
I have a programme that I use quite often that uses heaps of Loops to do
certain things however it is at the point of where it takes a long time to
get to the next thing from 30 seconds to about 2 minutes.