Need Help With Another Macro-

Larry Sulky · #10 04-04-2014, 06:26 AM

rsrasc, Thanks for the kind words. There are optimisations that could be made that I didn't bother with, since your files are pretty small. One that I should have made, however, is to stop screen updating while the macro is running. The macro jumps around a lot, which takes screen refresh time. At the beginning of the macro, you could add:

Code:

Application.ScreenUpdating = False

and at the end:

Code:

Application.ScreenUpdating = True

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
custom icon, undo/redo for macro, permanent macro	Rapier	Excel	0	08-05-2013 06:30 AM
How do I assign a macro to a button when the macro is in my personal workbook?	foolios	Excel Programming	2	07-27-2011 02:41 PM