speed of processing
Thanks
"Jim Thomlinson" wrote in message
...
Try this to suppress the screen updating (and speed up your code).
Application.screenupdateing = false
'Your code
application.screenupdating = true
--
HTH...
Jim Thomlinson
"Chas" wrote:
I am examining thousands or rows with my VBA. It is taking a long time.
I
think most of it is visual processing. The processing is: examine a
cell,
if applicable, copy that row to another sheet; repeat 5000 times. I
placed
"Application.WindowState = xlMinimized" at the beginning, but Excel does
not
minimize. Any help?
|