Deleting filtered results VBA

[Rehmatm]

Please can someone help...I want to be able to filter on a table and delete if the result is 'Yes' and then remove filters using VBA

Ay help, will be greatly appreciated

Thanks

Rehmat

 

[Joe4]

Have a look here:
https://www.mrexcel.com/forum/excel-questions/1084217-delete-all-rows-vba.html

You can then remove the filter by adding this code to the bottom:

    ActiveSheet.AutoFilterMode = False