The following macro copies the data from a dynamic range. However, for 30 rows it takes more than 10sec. This would possibly contain thousands of rows. How can I improve the speed?
Please Login or Register to view this content.
The following macro copies the data from a dynamic range. However, for 30 rows it takes more than 10sec. This would possibly contain thousands of rows. How can I improve the speed?
Please Login or Register to view this content.
Are you working over a network?
Are you familiar with ADO? Are your files password protected (it doesnt appear to be the case given the code above)? you can actually pull data from files WITHOUT opening them with ADO. I have a macro that rips through about 80 files (5,000 tabs) grabbing about 180MM cells of data in about an hour o_O with ADO. Without ADO it took something like 16+ hours because the files were so slow to open.
I also noticed Excel 2013 is slower to open than 2010...
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Does this help any?
Please Login or Register to view this content.
What point is the slowest in the code? Can you walk through it and determine what is taking the longest, then try to find a different approach?
And my question?
Used copy/paste instead and works perfect!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks