Macro Slow In Execution Under Excel 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro which checks and deletes certain line of data depending on the
details they hold. At times, it could be deleting a few hundred lines.

When run under Excel 2000 or 2003, it completes in about 20 seconds.

However, it's almost "hanging" when run under Excel 2002.

This was zeroed in to a simple EntireRow.Delete command. It takes about 20
to 30 seconds to delete each line.

Different PCs and OSes were used with the same result.

Anyone knows if there's a bug in Excel 2002? and any solution to fix it?

Thank you.
 
It may be the printdriver. Do you have pagebreaks visible. If so, turn
them off in your macro and see if that helps.
 
Both pagebreak and display had been turned off with not noticeable difference.

The strange thing is that it only happen with Excel 2002 and not 2000 or 2003.

Regards.
 
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

Win7 VirtualStore Weirdness with Excel 2002 and earlier 60
Macro slow down 3
looping excel macros 5
Shapes slow down Macro in Excel 2007 2
Excel 2002, VBA, macros and Windows 7 1
Macros Execute Very Slow Problem 1
Insert row very slow in Excel 2002 4
How to call Excel add-in macro from a button… 1

Back
Top