![]() |
|
|
|
#1
|
|||
|
|||
|
Hi, Paul ---
I read the FAQ that you referenced but I'm not clear on one point of protocol: if two members are testing and debugging code, should every iteration of that code be posted here? I ask because some of the things that rsrasc and I were working through were small, silly glitches, so each iteration of the code was 99% the same as the previous one. Cheers! --- larry |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
| Thread Tools | |
| Display Modes | |
|
|
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 |