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.
--
HTH,
Barb Reinhardt

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...
--
HTH...

Jim Thomlinson


"Barb Reinhardt" wrote:

> 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.
> --
> HTH,
> Barb Reinhardt
>

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



"Jim Thomlinson" wrote:

> 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...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Barb Reinhardt" wrote:
>
> > 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.
> > --
> > HTH,
> > Barb Reinhardt
> >