Thread
:
speed of processing
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett