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

HOW to make sub run more quickly
 

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


--
bobwilson
------------------------------------------------------------------------
bobwilson's Profile: http://www.excelforum.com/member.php...o&userid=33046
View this thread: http://www.excelforum.com/showthread...hreadid=530442