View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GrantS GrantS is offline
external usenet poster
 
Posts: 2
Default 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