Well in your workbook code, the bit that you have put in the post that deletes the empty rows has been commented out? I'd suggest you need to step through backwards though otherwise it will skip rows:
for count = Range("A" & rows.count).end(xlup).row to 1 step -1
   If Range("A" & count) = "" then rows(count).delete
next