Slow Macros ...3

S

Sanj

Hi Tom

The first time the code runs it works a treat 5 seconds
to delete the rows, however the second time it runs it
takes 25 seconds. I guess there is no getting around this.
 
P

Paul Mac

Try switching the view to Normal.

I have had a similar problem where it is in PBreak Preview.

Otherwise, pass Application.Save. That will also help if the spreadsheet has a lot of rows.

HTH, Paul.
 
Top