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

  • Thread starter Thread starter GrantS
  • Start date Start date
G

GrantS

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
 
application.screenupdating = false
'lots of code
application.screenupdating = true
 
Back
Top