HOW to make sub run more quickly

hi,

someone tells me, you should minimize the window of excel , when you run
your vba subs,

is that true,

why

thanks

Do you use the following in your Macro? I found this speeds up the process on my Macros.

With Application
.ScreenUpdating = False

'Your Code

.ScreenUpdating = True

End With

In addition to Bob's suggestion you should also look at the subroutine
itself. If it's taking a long time then you may be able to do some
optimization, this site has some good tips and tricks:
http://www.cpearson.com/excel/optimize.htm

You can do some performance testing yourself to see what part of your
subroutine is taking the longest and focus your efforts there.

Then, if you've applied all the optimization options and 1) the subroutine
is still taking a long time and 2) there are parallelizable processing
happening then you might want to consider modifying the workbook to run on a
grid. You can find more about that at www.digipede.net. The Excel white
paper will be available soon, but you can see here:
http://krgreenlee.blogspot.com/2006/...741944546.html the process I went through to grid-enable a long-running workbook.

Good luck,

Kim Greenlee

--
digipede - Many legs make light work.
Grid computing for the real world.
http://www.digipede.net
http://krgreenlee.blogspot.net