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

  • Thread starter Thread starter shirley_kee
  • Start date Start date
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help!!! I have problem deleting 2500 rows of filtered rows 1
Calculate number of rows and apply formula 4
Delete all rows except 2
Excel 2007 - Deleting Filtered Rows 3
delete row if cell value = 4
Excel Macro for deleting Rows containing dates greater than "today" 0
delete only visible rows in filter mode 4
Variable row groupings 3

Back
Top