Slow Excel 2002 Macros

  • Thread starter Thread starter Chris Cradic
  • Start date Start date
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.
 
Hi
you may post the (relevant part of) your macro.

Also try adding lines like
application.screenupdating=False
'your code
application.screenupdating=True
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP - Excel 2003 VERY SLOW vs 2002 1
Are macros inherently slow in Excel 2007 3
How to find out the cause for Excel 2007 slower than Excel 2003? 4
Is there a fix for the slowness in excel 2007? 7
Slow to open 3
excel 2002 run slow 1
Excel 2007 macros with drawing objects 1
Excel Extremely Slow 2

Back
Top