Help!! I have problem deleting 2500 rows of filtered rows!!!!
 

I have total of 156 columns and 3900 rows with 20 columns of formula for
each row. My filtered result is 2500 rows. I tried to delete 2500 rows
in my excel but it took me more than half an hour to delete it either
by vba code or manually by excel. I tried using office clipboard
manually, it paste the data as value and my formula isn't there
anymore.

Anybody has any idea how to write a vba program to solve this problem
and how to write a office clipboard in vba.


Please help... anybody...

:( DESPERATE FOR THE ANSWER


--
shirley_kee
------------------------------------------------------------------------
shirley_kee's Profile: http://www.excelforum.com/member.php...o&userid=30384
View this thread: http://www.excelforum.com/showthread...hreadid=500486

Help!! I have problem deleting 2500 rows of filtered rows!!!!
 

You have a reply to your post in .programming.

shirley_kee wrote:

I have total of 156 columns and 3900 rows with 20 columns of formula for
each row. My filtered result is 2500 rows. I tried to delete 2500 rows
in my excel but it took me more than half an hour to delete it either
by vba code or manually by excel. I tried using office clipboard
manually, it paste the data as value and my formula isn't there
anymore.

Anybody has any idea how to write a vba program to solve this problem
and how to write a office clipboard in vba.

Please help... anybody...

:( DESPERATE FOR THE ANSWER

--
shirley_kee
------------------------------------------------------------------------
shirley_kee's Profile: http://www.excelforum.com/member.php...o&userid=30384
View this thread: http://www.excelforum.com/showthread...hreadid=500486

--

Dave Peterson