Application.ScreenUpdating

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

Barb Reinhardt

I've used this line of code for over a year with no problems. Today it's
giving an error.

If Not ScreenUpDate = True Then Application.ScreenUpdating = False

ScreenUpdate is BOOLEAN.

I'm getting Run-time error '50290'
Method 'ScreenUpdating' of object '_Application' failed.

What the ....

FWIW, I'm still using Office 2003.
 
If you add the line Application.screenupdateing = false just ahead of that
line of code will it Execute ok. One thing to check would be Tools ->
References in the VBE as one of your references might have gone south on you
which can generate some pretty odd errors...
 
I'll check it, thanks. I have had issues with missing references and I could
kinda figure out it was a reference issue. This was strange. I'll let you
know if I find something (and it happens again)
Thanks,
Barb Reinhardt
 
Sometimes Excel is just not ready:

If Application.Ready Then
Application.ScreenUpdating = True
End If
 
Back
Top