Hi,
Many thanx for my previous post for the best replies.
Now i am stuck with Application.ScreenUpdating.
My Code is:
but it's not working it always being true.Code:Application.ScreenUpdating = False
:confused:
Printable View
Hi,
Many thanx for my previous post for the best replies.
Now i am stuck with Application.ScreenUpdating.
My Code is:
but it's not working it always being true.Code:Application.ScreenUpdating = False
:confused:
Hi,
In each sub routine set the screen updating like
Code:Dim lngSU As Long
With Application
lngSU = .ScreenUpdating
.ScreenUpdating = False
End With
'Your code
Application.ScreenUpdating = lngSU
Thanx for this useful function.
Working!
:cool: