.Delete speed

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Very slow when I delete Row...how to speed up?	leungkong	Microsoft Excel Programming	10	8th Dec 2008 06:55 AM
Vista speed and delete issue	=?Utf-8?B?QXhlbA==?=	Windows Vista Performance	13	29th Aug 2007 03:21 PM
Speed Up A Macro / Delete Worksheets	robbywvut@hotmail.com	Microsoft Excel Programming	1	19th Sep 2005 05:53 PM
How do I get the backspace delete function to speed up?	=?Utf-8?B?RmluZnJlYWs=?=	Microsoft Word Document Management	1	4th Feb 2005 10:57 PM
How to Delete "My Documents," & Speed Up Menus	vincent christopher	Windows XP Basics	6	31st Jul 2003 11:24 PM