Thanks Robert!

One problem though.

The last couple of cells in column A are empty. Thus the macro does not select those last few and they are left empty once the macro is done. Advice?

Other than that, this is exactly what I'm looking for.