I'm currently using autofilter to filter on two columns. If the result of the autofilter is blank for only visible cells, it will add a new row. If any rows other than the header are found, it will instead show a MsgBox. The problem is that the row count is always returning 1. I've tried redefining "rng" a few ways to no avail. 

```
Dim ws As Worksheet
Dim rng As Range

Set ws = Sheets("Scored Items")

Worksheets("Scored Items").Activate

ws.AutoFilterMode = False

With ws

    .Range("A:D").AutoFilter Field:=1, Criteria1:=AssetBox.Text
    .Range("A:D").AutoFilter Field:=4, Criteria1:=PartBox.Text

    Set rng = .Range("A:A").SpecialCells(xlCellTypeVisible)

    If (rng.Rows.Count = 1) Then
        'Add new row based on VBA form
    Else
        MsgBox "Item has already been scored"
    End If
End With

ws.Cells.AutoFilter

```