在宏期间停止屏幕闪烁 [英] Stop screen flicker during macro
本文介绍了在宏期间停止屏幕闪烁的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好。 我以前知道怎么做,我忘记了:(
Hi all. I used to know how to do this, I forgot :(
我需要一行代码来阻止屏幕在宏观期间闪烁,我清理单元格,应用过滤器,移动到不同的工作表,屏幕在处理每个动作时从一个区域闪烁到另一个区域...
What is the line of code I need to stop the screen from flickering during a macro, I have it clearing cells, applying filters, moving to different worksheets, and the screen flickers from one area to another as it processes each action...
谢谢!
Lisa
推荐答案
Lisa,
re: whatzit called
Application.ScreenUpdating = False
Lisa,
re: whatzit called
Application.ScreenUpdating = False
'--- ---
Jim Cone
美国俄勒冈州波特兰市
https://goo.gl/IUQUN2 (Dropbox)
Jim Cone
美国俄勒冈州波特兰市
https://goo.gl/IUQUN2 (Dropbox)
'---
Jim Cone
Portland, Oregon USA
https://goo.gl/IUQUN2 (Dropbox)
Jim Cone
Portland, Oregon USA
https://goo.gl/IUQUN2 (Dropbox)
这篇关于在宏期间停止屏幕闪烁的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文