Hello,
I'm using this code to verify values, and copy cells from one sheet to another in the same workbook...... the code works fine. but is really slow and Inefficient.
can you help me make the code run better.
Please Login or Register to view this content.
Thanks
virgiliocabrera
Last edited by Leith Ross; 08-01-2011 at 06:58 PM.
virgiliocabrera,
Give the following a try:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
One thing that really accelerate a macro is to stop the screen updating at the beginning of the code and reactivating it at the end.
Please Login or Register to view this content.
Re: making code more Efficient !!! please help
I would use a combination of tigeravatar's excellent code and p24leclerc's suggestion of disabling the screen updating, but would also disable calculations and worksheet events which, if exist, can cause looping issues. I wouldn't just say off and on though. I've made it a habit of getting the existing settings and then restoring them at the end of the routine. If you've ever called other routines from another, you'll understand why this could be important. Thanks!
-Greg
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks