![]() |
|
|
|
#1
|
|||
|
|||
|
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 Code:
Application.ScreenUpdating = True |
|
#2
|
|||
|
|||
|
I will add the new code and will continue testing the macro. Out of 60 documents I'm down now to 27 more. What a great feeling!
Dear Macropod, Please consider this thread closed and I would like to see the stamp "solved". It is so nice to see it. Out of four (4) request, so far all of them have been resolved. Hummm, good score! I'm hoping that any future request can be solved thru the forum so I don't have to damage my scoring average!. The only reason I asked Larry for support it was because no one responded to my request. If this is a sin, I apologize for that. I hope things will get better in the future. Sincerely, Roberto |
|
|
|
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 |