VBA Code to Filter and Delete Rows

I use Excel 2010. I run VBA code on this one table everyday. I currently have to do it partly manually, because it deletes more rows than I want it to.

My goal is to filter the spreadsheet using this criteria:
Filter column 22 = "NEP", also filter column 16 = "Groom".
Then, I wish to delete all rows left (after filtered) that contains "ONSP" or "Offnet" in column G1.
This last statement doesn't work. Instead, it deletes ALL rows that contain "ONSP" or "Offnet", whether filtered or not.

Here's my code (I hope it makes sense):

-------------------------------------------------------

Please Login or Register  to view this content.

--------------------------------------------------------
Thanks,
Greg

How about this? Will this delete the rows you are hoping to delete (leaving you with the rows you wish to have remaining)?

Please Login or Register  to view this content.

I assume you have column headings and that they are in Row 1.
_____________
[1] If this reply was helpful, click the star to the left.
[2] If this reply answered your question, mark this thread as [SOLVED].