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

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

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

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

How to set equivalent of Visual Basic "redraw = false"
 

Thanks for the help folks. These work.
Cheers

Grant