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

[radian89]

trackback
https://www.mrexcel.com/forum/excel-...-x-delete.html

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, or maybe there's other method?

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

thanks for the help guys!
much appreciate

Case.jpg

[radian89]

Hi all,

solved!

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.