Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set equivalent of Visual Basic "redraw = false"
Hi
I am wanting to stop the flickering of a work sheet while looping through the rows and fields to perform some formatting and calculation funtions. Is there an option similar to Visual Basic's "Redraw=False" to maintain the screen (WorkSheet) while the operations are performed? I have hunted the Excel Object model but not found anything that seems to do the trick. Thanks in anticipation. Grant |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic "Blinking" Cursor??? | Excel Discussion (Misc queries) | |||
Excel crashes on "Close" Visual Basic error 400 | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
"Microsoft Visual Basic runtime error '424' object required". | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |