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?

As always, post your code. You are probably using a lot of unnecessary
selections when a loop would do

for i= 1 to 10000
if cells(i,1)="joe" then
next i

--
Don Guillett
SalesAid Software

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

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?

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?