excel vba - DELETE from ListObject table rows meeting condition using VBA -


is possible in vba delete rows meeting condition excel listobject table? looking similar sql statement:

delete mylistobjecttable mycolumn='some condition'

try this:

.- break connection,

.- sort listobject per condition (optional have results of condition in 1 range.area deletion),

.- autofilter listobject per condition,

.- delete visible rows of listobject.databodyrange

.- clear autofilter


Comments

Popular posts from this blog

javascript - Clear button on addentry page doesn't work -

python - Error: Unresolved reference 'selenium' What is the reason? -

asp.net ajax - Jquery scroll to element just goes to top of page -