| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - How do I delete filtered out rows? | Excel Discussion (Misc queries) | |||
| excel deleting rows last cell does not change. How to change? | Excel Discussion (Misc queries) | |||
| Deleting Rows using Macros | Excel Discussion (Misc queries) | |||
| Why does # of filtered rows appear in status bar only sometimes? | Excel Discussion (Misc queries) | |||
| Is there a limit to the number of rows that can be filtered | Excel Worksheet Functions | |||
Linear Mode
