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??
|