VBA delete rows that don't contain the character /

Hi All, i want a VBA code to delete all rows that donot contain the "/" character. So column D contains part numbers in my sheet. We have two formats for part numbers one contains only numbers and the other will always have a / in it.
I have tried the following code but this deletes all rows, however if i change the value to a specific value that i can see is in my spreadsheet it does delete all rows other than the row with the specific value.
I was trying to use "*/*" hoping this would search on anything in the cell that contains /.
the codes is shown below, any help would be appreciated.

Please Login or Register  to view this content.

The <> operator does not use wildcards. It takes all characters literally. Try this:

Please Login or Register  to view this content.