Macro to Delete Entire Row Based on Formula in Given Column

If my understanding is correct you are trying to delete the rows in column E which have a blank value. Try this:

Please Login or Register  to view this content.

Try change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Do you know why my code was only deleting half of the rows at a time?

Yes but it is hard to explain. Yasser showed how to do it your way properly.

When a row is deleted, the rows below it "move up" and a renumbered.
Ex. When you delete row 10, row 11 moves up and becomes the new row 10.

A loop like "For rowNum = 10 to 20" will therefore delete the intended rows, but rather every 2nd one in the set.

Solution:
When deleting rows, you need to work backwards, from the bottom up so that no rows are renumbered in the intended list.

Hope this helps.

To give you a visual of what Stu is saying.
Put the number 2 in row 10 and row 11.
Now imagine your code is currently looking at row 10 and you are deleting rows with the number 2 in them. Manually delete row 10, you will see that correctly the row with the 2 in it is gone, but the other 2 moved up and the row with that 2 in it is now row 10, now your code having done what you asked it to do now looks at row 11. The 2 in row 10 will now be left in place.
This is why you go from the bottom up.
Imagine your code was starting at row 11 and moving up. Delete row 11 and you will see the 2 is gone and that row 10 which is the next row you will be checking has a 2 waiting for you.