Slow Excel 2002 Macros

C

Chris Cradic

Any ideas on why a Macro would would run slower on Excel
2002?? They run great on earlier versions of Excel. Is
it XP-Pro related?? It's like it's cache related, it
runs fast at the start then becomes slower and slower.
It's evaluating the first cell of a row, if it does not
contain a certain variable we're looking for, it deletes
the entire row.

We've tried to re-do the macro in Excel 2002 thinking
that maybe the functions have changed but end up with the
exact same syntax.
 
F

Frank Kabel

Hi
you may post the (relevant part of) your macro.

Also try adding lines like
application.screenupdating=False
'your code
application.screenupdating=True
 
Top