speed of processing
 

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?

speed of processing
 

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?

speed of processing
 

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?

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?