Excel Screen Update......

[Static]

Does anyone know how to turn the screen update off in excel

I thought it was...
Dim O as object
Set O = CreateObject("excel.application")
O.screenupdate = false

Nope....Doesn't work

[HDR]

I don't understand what you are asking. What do you mean by screen update? Of course, if you know how to do it in Excel, just record a macro and see how to do it in automation.

[Static]

It was...

.screenupdating = false

makes automation faster....then
true when done...displays data.

[Nitro]

Try this:

Option Explicit

Sub Main()
  Application.ScreenUpdating = False
  
  Dim int_X As Integer
  Range("A1").Select
  Do
    int_X = int_X + 1
    ActiveCell.Value = int_X
    ActiveCell.Offset(1, 0).Select
  Loop Until int_X = 4000
End Sub

If this work, you will see all data in cells at once.