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!!!!
Bookmarks