i don't see any flashing, just the updated data after it sorts

Private Sub Worksheet_Calculate()
Application.ScreenUpdating = False
Range("A2:V40").Sort Key1:=Range("T2"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Application.ScreenUpdating = True
End Sub

--


Gary


"Simon Lloyd" wrote
in message ...

I have tried the ScreenUpdating before the with but it made no change,
the flicker is there every time it sorts!

Regards,

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=525605