Delete rows if column contains a blank code included

Hello I need help filling out this macro that i've pulled from another thread.
And here is the code

Please Login or Register  to view this content.

My row is BE3:BE14204 That way if there is a blank within that range (column range) it deletes the entire row. I keep getting a syntax error, what is going wrong?

The debugger highlights the first part "Sub delete_rows_blank()"

Try this

1/. Filter your Data on Column BE for Blanks
2/. Select all of the resultant rows, and Delete them (Delete > Rows)
3/. Remove the filter.

Hope this helps