Why does Selection.PasteSpecial toggle Application.ScreenUpdating
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
|