Slow Macros ...3

  • Thread starter Thread starter Sanj
  • Start date Start date
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.
 
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.
 
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

Processing time 1
Should I be content with the time code takes? 2
processing time (revised and re-posted) 10
Run two macros for two different sheets 11
Run Macro If Cell have "x" value 0
AutoFilter Slow problem 1
Macro speed decreesing after each run 6
Don't want to hard-code file name in macro 3

Back
Top