If the activating of the sheet is removed, the flicker seems worse with
application.ScreenUpdating being turned off and on.

--
Regards,
Tom Ogilvy

"Don Guillett" wrote in message
...
application.screenupdating=false
code
reset to true

--
Don Guillett
SalesAid Software

"wayne" wrote in message
om...
Hi

When I use the following script in Microsoft Excel to automatically
update a figure based on a yes/no condition in cell c20 the screen
flickers. The value and program does work but it is very pleasant to
watch. Can anyone help?


Wayne


Private Sub Worksheet_Calculate()
Sheets("Work Order Request").Select

If Range("c20").Value = "yes" Then
Range("g20").Value = "=c18"
Else
Range("g20").Value = "Enter CBA Number"
End If
' Range("g20").Value = "=c18"
End Sub