View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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?