I have an excel sheet with several command buttons. Each trigger different ranges to autofilter within the worksheet. The one giving me problems employs the following code:

Private Sub cmdFilterMaterials_Click()
Sheet1.Unprotect
With Sheet1
.Range("$A$5:$A$447").AutoFilter Field:=1, Criteria1:="<>", Operator:=xlAnd, Criteria2:="<>0", visibledropdown:=False
End With
Sheet1.Protect
End Sub

That range works fine. When I increase the range by one row (448 or onward) it filters the entire worksheet rather than the range I want (all the way up to row 1080).

Please help!