Bright01
asked on
Using "ScreenUpdating"
EE Pros,
I have a simple macro that when fired, causes a flicker as it runs. I've tried to use the "Application.Screenupdatin g = False, but either have it in the wrong place or am not using the correct line of code. Any help would be appreciated.
Thanks in advance,
B.
Edit: Code placed in snippet with thanks and Initial removed to end
GrahamSkan
I have a simple macro that when fired, causes a flicker as it runs. I've tried to use the "Application.Screenupdatin
Sub RestoreValueProps()
On Error Resume Next
With ActiveSheet
Application.ScreenUpdating = False
.Range("G12") = "=I150"
.Range("G14") = "=I151"
.Range("G16") = "=I152"
.Range("G18") = "=I153"
.Range("G20") = "=I154"
.Range("G22") = "=I155"
.Range("G24") = "=I156"
.Range("G26") = "=I157"
End With
End Sub
Thanks in advance,
B.
Edit: Code placed in snippet with thanks and Initial removed to end
GrahamSkan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Pleased to help
ASKER