Hi. At the end of the month I have 1 sheet that has like 15k rows, and my friend wrote me a macro to delete the rows but I feel like it runs slow. Is there a faster way to delete all row? Here is what I found in the code windows when I click "edit" the macro
Please Login or Register to view this content.
What are you trying to accomplish? Just deleting all the rows on the sheet and starting over minus the header row maybe?
Note:
I had the same thought as tigeravatar, here is my attempt...
Please Login or Register to view this content.
Last edited by jeffreybrown; 04-20-2012 at 01:53 PM. Reason: added code
HTH
Regards, Jeff
shinichi_nguyen,
Is it required the rows be deleted? This will clear the cells including formatting except for the headers. Cleared 16000 rows basically instantly:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks