Hi Guys. So I am using VBA to AutoFilter a row in a table with conditions. Now I need to delete the entire row. My limited experience with VBA only allows me to select the row and delete, but the row number could change every time.
Sub AutoFilterDelete()
ActiveSheet.ListObjects("VendorCertFrmFile").Range.AutoFilter Field:=2, _
Criteria1:="Appliances Medical Devices Cosmetics"
Rows("157:157").Select (This value will change every time. I need to select the entire row based on the criteria.)
Selection.Delete Shift:=xlUp
End Sub
Sub AutoFilterDelete()
ActiveSheet.ListObjects("VendorCertFrmFile").Range.AutoFilter Field:=2, _
Criteria1:="Appliances Medical Devices Cosmetics"
Rows("157:157").Select (This value will change every time. I need to select the entire row based on the criteria.)
Selection.Delete Shift:=xlUp
End Sub