Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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=500484 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Permanently Deleting filtered rows | Excel Discussion (Misc queries) | |||
Deleting filtered rows in Excel | Excel Discussion (Misc queries) | |||
Deleting filtered rows in Excel | Excel Discussion (Misc queries) | |||
Inserting Blank rows after every row upto 2500 rows | Excel Worksheet Functions | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) |