PC Review


Reply
Thread Tools Rate Thread

.Delete speed

 
 
cht13er
Guest
Posts: n/a
 
      3rd Mar 2008
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
 
Reply With Quote
 
 
 
 
ytayta555
Guest
Posts: n/a
 
      3rd Mar 2008
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
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:06 PM.