Code look through range of cells, find blanks & delete cell range in the same row,

I am new to using vba and just understand the basics. THerefore would really appreciate your help.

I have a list of data, such as the below, across 6 columns. I need a macro that will search through a named range of all columns, then identify if the cell is a blank and if so delete a range of cells in the same row (ie below cells a2 to f2).

In the example below, the result of the macro should be to have only the last two rows remain as the others all have blanks.

Thank you!

X1 X2 X3 X4 X5
Feb-07
Mar-07 0.57%
Apr-07 2.55%
May-07 1.34%
Jun-07 -5.88% -0.13%
Jul-07 0.67% 4.44%
Aug-07 0.01% 2.55% 5.73%
Sep-07 0.89% 1.34% -0.21%
Oct-07 3.24% -5.88% 1.45%
Nov-07 -0.13% 0.67% 5.10%
Dec-07 4.44% 5.73% 5.80%
Jan-08 5.73% -0.21% 0.57%
Feb-08 -0.21% -0.21% 2.55%
Mar-08 1.27% 1.27% 1.34%
Apr-08 -0.88% -0.88% -6.71%
May-08 -0.75% -0.75% -0.25%
Jun-08 5.66% 1.25% 1.25% 2.55% 1.00%
Jul-08 3.22% 4.00% 4.00% -1.66% 2.00%