VBA Code禁止屏幕滚动

在更新之前加上ScreenUpdating = False，屏幕就不会滚动:

Application.ScreenUpdating = False
Sheet1.Range("D180").Select
Application.ScreenUpdating = True

posted @ 2013-11-08 04:37 Leon_Chao 阅读(640) 评论(0) 收藏举报