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?