.Delete speed

  • Thread starter Thread starter cht13er
  • Start date Start date
C

cht13er

Can anyone try to explain why "ActiveCell.EntireRow.Delete xlUp" is so
much quicker than "ActiveCell.Delete xlUp"?

I have screen updating and calculations turned off, and
ActiveCell.Delete xlUp is still SO SLOW!

Thanks for any answers and/or links!

Chris
 
HI , cht 13er
Try to change ,,Delete" with ,,ClearContents" ;
I needed also speed for delete contents , and I
tried between this two comands ; ClearContents
work incomparabile faster ; succes

DDE
 
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

Pls help: macro to delete empty rows 4
Delete Rows with Loop Statement 4
Very slow when I delete Row...how to speed up? 10
vlookup issue 2
Move line as Worksheet change not working correctly 3
removing blank rows taking a long time 4
Question regarding returning a variable value to a cell 2
Please help debug this code! 1

Back
Top