Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there
I'm running a macro that is called from another macro ans updating has been set to false. However, under some circumstances I can still see the screen being populated, and of course the macro runs very slowly indeed. For debugging I included the following lines: Application.ScreenUpdating = True If Application.ScreenUpdating = True Then: MsgBox "TRUE" Application.ScreenUpdating = False If Application.ScreenUpdating = False Then: MsgBox "FALSE" code immediately after this populates the page (which is what I can see happening) There NO OTHER REFERENCES to updating, except at the end of the caller. Of course both msgboxes come up (as I would expect, but I can still see the population happening, so obviously updating is not false at all or................there's something else going on that I don't understand. Does anyone have an idea here please? Regards, Brett |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
screenupdating=false not working | Excel Programming | |||
ScreenUpdating = FALSE | Excel Programming | |||
How to set Application.ScreenUpdating = False for Gen use | Excel Discussion (Misc queries) | |||
What does ScreenUpdating = False do? | Excel Worksheet Functions | |||
Application.ScreenUpdating = False | Excel Programming |