Excel: Filter not work

I have formula in F1 i try this code but dont work.

Sub notWorkFilter()    If Range("F1") > 0 Then
       Range("C16").AutoFilter Field:=1, Criteria1:=Range("D6").Value
      Exit Sub
    End If
End Sub

This question generated 26 answers. To proceed to the answers, click here.

This thread is current as of November 02, 2013.

For more resources for Microsoft Excel