Hi there

I have a basic macro that will activate when a certain cell is changed to autofilter the results that are produced from that change. Unfortunately the spreadsheet takes variable amounts of time to recalculate and the autofilter happens before all the calculations are complete. What I was hoping for was an addition to this macro so that the autofilter does not start until after the calculations are complete?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$4" Then
Application.EnableEvents = False
Selection.AutoFilter Field:=10, Criteria1:="<>0", Operator:=xlAnd
Application.EnableEvents = True
End If
End Sub
Can anyone help?
Thanks.