Screen update?
I can not remember the format and code to keep the screen from updating as
the code executes. "screen.update = false" or something similar, then when done "screen.update = true". Thanks you -- David |
Screen update?
David,
Application.ScreenUpdating = False Application.ScreenUpdating = True -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "David" wrote in message ... I can not remember the format and code to keep the screen from updating as the code executes. "screen.update = false" or something similar, then when done "screen.update = true". Thanks you -- David |
All times are GMT +1. The time now is 12:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com