View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
plh plh is offline
external usenet poster
 
Posts: 48
Default Fastest way to delete rows

Hey ytayta555,
I gotta thank you for that, because I was having the same problem with deleting
rows, but was able to find a work around using ClearContents, which turned
minutes into seconds.
-plh

In article ,
ytayta555 says...

On 2 Sep, 19:27, Brian wrote:
Thanks for the help. =A0I guess I made it too complicated. =A0I'm using m=

y code
to go through once I filtered and deleted the data the first time, and it
works much quicker.


=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Rows(c).Delete


I have found that for me method ClearContents work faster then
Delete .
Am I right ?



--
Where are we going and why am I in this HAND BASKET??