View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Macro Slow In Execution Under Excel 2002

It may be the printdriver. Do you have pagebreaks visible. If so, turn
them off in your macro and see if that helps.

--
Regards,
Tom Ogilvy

"samson" wrote in message
...
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.