VBA Code to remove Data embedded in the "Pick From Drop Down List"

[p45cal]

Thank you p45cal. I tried it and it didn't work. It didn't delete the rows that look blank. And I right clicked them and the values are still there. Am I doing this wrong?

1. You do realise I used .Entirerow.Select and not .Delete in my snippet?
2. It worked on the file you attached.