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:

Please Login or Register  to view this content.

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 !!!

I hope this time my message is correct !

Hi
You very rarely need to select objects. You can simply refer to them directly. For instance in this case you'd probably refer to the filtered rows with the SpecialCells(xlCellTypeVisible) instruction and use .EntireRow.Delete

HTH

Thanks Richard and as well Yeaster (in my last post) ! I think I am really close but actually I need only more tip: What do I need to put before SpecialCells(xlCellTypeVisible) ? because I am receiving Sub or function not defined.

Thanks again for your help for this very basic question ....

Sorry I can t find it again: it says "cannot use that command on overlapping selection " Maybe is it because my filter is in row 1 ?

Thanks !

Sorry but I still have this message appearing with yellow background on the last line

Please Login or Register  to view this content.

Yes, here is attached ! Hope this can help ! I have deleted some columns for data privacy but actually there were more columns and some were hidden (myabe that can be the reason ?? )

Thanks

Your code is working on the small file ! It must come from my hidden columns on my original file ! Well, I will try to fix this !!

Thanks a lot all for your help !!!

Bump no response

Working perfectly !! Thanks a lot mate !

Hi,

Assuming your table of records started in A10 with row 10 being the column headers, something like:

Please Login or Register  to view this content.

HTH