Excel Screen Update......

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

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.

It was...

.screenupdating = false

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

Try this:

Code:

---

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.