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
Printable View
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:
If this work, you will see all data in cells at once.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