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

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