View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default 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