LinkBack URL
About LinkBacks
hi,
this is working very slow, need some modification to work faster
Please Login or Register to view this content.
hi,
this is working very slow, need some modification to work faster
Please Login or Register to view this content.
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
I have not had the chance to test this but perhaps
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Xlnitwit like this
@xlnitwit,
Toggling Calculation Mode will have a significant impact, and I believe you could tweak your Code as shown below;
Regards.Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
@Winon,
It may speed things up, it may not. It will depend on the workbook.
Also, without knowing the workbook structure, I cannot be sure if turning off calculation would result in the wrong values being pasted somewhere. In fact, it may be the case that the order of copying and pasting affects the results of other columns that are then copied and pasted, in which case my suggestion would not work at all.
Last edited by xlnitwit; 02-28-2017 at 02:46 PM.
Just for interest sake. What would the last used cell in Column B be under normal circumstances?
Is this slow also?
Try it on a copy of your receiving workbook and with both workbooks open.
I would think that it is slower then the codes in Post 2 and Post 4.
Please Login or Register to view this content.
Administrative Note:
- We would love to continue to help you with your query, but first, before we can proceed…
- Please see Forum Rule #1 about proper thread titles and adjust accordingly...
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks