Delete Rows After a filter

Hello,


I used to work a lot on VBA but now I forgot almost everything and I would need your help to restart again my work on VBA. I have a worksheet with data from Column A to AA and I have a filter on Row 1. I would like to select from this filter a certain value for column D and then delete the rows I dont need. So my code starts like this:

 Sheets("Export").Select
 Selection.AutoFilter Field:=4, Criteria1:="<>MY", Operator:=xlAnd

But after that I would like to delete the rows that are matching the criteria <> MY. Do I need to select manually the rows and then after make Selection.delete or does it exist a code that can directly delete the rows that I have selected (<> MY) ?

Thank you for your help !!!
please Tell me if my description is not clear... so much time I have past since my last visit on this website !