![]() |
ScreenUpdate Usage
Hi Clara,
The screen will not update at all until you reset application.screenupdating = True. Cheers, Ewan. "clara" wrote: Hi all, I have a macro in the following layout sub MyMacro() application.screenupdating = false ... FirstCall() ... SecondCall() end sub if some statements in firstcall() or secondcall() will make screen flick, do I have to put application.screenupdating =false inside each of them? CLara -- thank you so much for your help |
All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com