I have a Excel worksheet using cells A1 to H430. There are quite a few empty
lines in this area, and when I print it out I don't want the empty lines. I
want to write a macro that will check column A (row headings), if one cell
has no content then the macro will hide the whole row.

Can someone please show me how this can be done in VBA code? Thanks a lot.