Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
What version of xl are you using?
I can't emulate the problem in either xl2007 or xl2002. I copied your code exactly and renamed a worksheet to Viewer and even inserted a volatile formula with RANDBETWEEN in M11 and there is definitely no screen updating until after the code is finished. I tested with Application.ScreenUpdating = False inserted both before and after the worksheet selection line. Can you see if Range("M13:M204") is actually updated while the Point 2 msgbox is still displayed? -- Regards, OssieMac |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to set Application.ScreenUpdating = False for Gen use | Excel Discussion (Misc queries) | |||
Screenupdating Problems | Excel Discussion (Misc queries) | |||
Application.ScreenUpdating function question | Excel Worksheet Functions | |||
Wide Selection of Absolute Reference Toggle | Excel Discussion (Misc queries) |