.Delete speed
 

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

.Delete speed
 

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