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%

Hi and welcome to the forum,
There are many way to do it.... here's one.
Looping through all rows from the end and delete if number of filled cells <> 6

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi,
I've added some comment to the code :

Please Login or Register  to view this content.

If I understand correctly, if C1 and E1 are empty then it should not be considered in the analysis?
Will it always be the same columns or not ?

Will this work ?

Please Login or Register  to view this content.