Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-04-2014, 06:26 AM
Larry Sulky Larry Sulky is offline Need Help With Another Macro- Windows 7 64bit Need Help With Another Macro- Office 2010 64bit
Novice
 
Join Date: Mar 2014
Posts: 14
Larry Sulky is on a distinguished road
Default Screen updating

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

Reply With Quote
  #2  
Old 04-04-2014, 06:41 AM
rsrasc rsrasc is offline Need Help With Another Macro- Windows 7 64bit Need Help With Another Macro- Office 2010 64bit
Competent Performer
Need Help With Another Macro-
 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default Thanks Larry!

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
Reply With Quote
Reply



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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft