worksheet change event - filter issue

hello all



i have the following macro that filters data on worksheet change event



the issue is....i would like for it to filter row 13...my name is "_Data"

    If Target.Address = "$U$7" Then
        Application.ScreenUpdating = False
    
    With Range("_Data")
        .AutoFilter
        For c = 1 To .Columns.Count
            .AutoFilter field:=c, visibledropdown:=False
        Next c
        .AutoFilter field:=19, Criteria1:=Range("MPLink").Value
    End With
    
    Range("Header") = "Filtered by: M/P"
    Application.ScreenUpdating = False
End If

however, my name ranged "_DATA" starts at row 14...therefore when i filter, it does not filter row 13....i dont want to change my defined name as it links to alot of other sheets....is there in the macro after "_DATA" where i can make the macro go up one row from _Data?



pls help!!!!

Try this -

With Range("_Data")
        .offset(-1,0).AutoFilter
        For c = 1 To .Columns.Count