| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to set equivalent of Visual Basic "redraw = false"
Try this.
APPLICATION.ScreenUpdating =FALSE set it back to true when you have finished. Robin Hammond www.enhanceddatasystems.com "GrantS" wrote in message om... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to set equivalent of Visual Basic "redraw = false"
Grant,
Application.ScreenUpdating = False hth, Doug "GrantS" wrote in message om... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to set equivalent of Visual Basic "redraw = false"
application.screenupdating = false
'lots of code application.screenupdating = true GrantS wrote: 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 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to set equivalent of Visual Basic "redraw = false"
Thanks for the help folks. These work.
Cheers Grant |
| Reply |
| 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 | |||
Linear Mode
