Autofilter and header row

[ge0rge]

I have two header type rows on my worksheet. I am using this code to autofilter the sheet:

Private Sub cmdSort_Click()
If UserForm1.txtParts.Value = "" Then
Exit Sub
End If
Columns("B:B").Select
    Selection.AutoFilter
    Selection.AutoFilter Field:=1, Criteria1:=UserForm1.txtParts.Value
Unload Me
End Sub

When it filters, I lose my header rows (rows 1 & 2). I really want to filter from Row3 and on. Is this possible? Thanks.

 

[JackDanIce]

Try this instead:

Private Sub cmdSort_Click()
Dim i as Long
If UserForm1.txtParts.Value = "" Then Exit Sub
i = Range("B" & Rows.Count).End(xlUp).Row
With Range("B3:B" & i)
    .AutoFilter
    .AutoFilter Field:=1, Criteria1:=UserForm1.txtParts.Value
End With
Unload Me
End Sub

 

[ge0rge]

I changed this line as such:

With Range("B2:B" & i)

Thank You, works as needed.