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

S

shirley_kee

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
 
D

Dave Peterson

You have a reply to your post in .programming.

shirley_kee said:
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
Click to expand...
 
Top