Dynamic based on criterias, Delete Excel Table with Selection.ListObject.ListRows(x).Delete

[radian89]

Hi All,

I need some help, I can manage to delete rows dynamically.. but idk on how to delete table dynamically based on criterias with Selection.ListObject.ListRows(x).Delete command

example below, how to delete "Bread" - type only using VBA?

thanks for the help guys!
much appreciate

 

[radian89]

Hi all,

solved!

Dim i As IntegerDim Tbl As ListObject


Set Tbl = Sheets("Sheet1").ListObjects("Foodie")


Tbl.Range.Rows("5:7").Delete

or you can make it dynamic as referring it to name range

Tbl.Range.Rows(Range("RangeDelete").Value).Delete