Excel 2007 : Need Macro to Hide Rows If Cells In Two Ranges Are Empty

I have placed a button on sheet one (titled "SETUP") of the attached workbook. When that button is clicked, I need a macro that will loop through two separate cell ranges on sheet two ("Jobs1" and "Jobs2") and hide any rows where there are empty cells in those ranges.

The cell range "Jobs1" refers to A4:A25 and the range "Jobs2" refers to A28:A39.

I'm not experienced in visual basic, so nothing I've tried seems to be working.

Thanks in advance for the help!