Macro to hide blank (not empty) rows

Hi everyone,

I have a template from rows 5 - 700.

All cells in column A between 5 - 700 has a formula in it. The formula is set up so that if there is an unapplicable result from the source worksheet, the cell appears blank.

I'm very new to macros. Can anyone help me develop a macro which can be attached to a button that would hide all rows that have a blank cell in column A between rows 5 - 700? Again, the cell is BLANK, but it is not empty.

Thanks very much, everyone!!