At the end of each row there is a formula that adds the number of blank spaces in a range of 25 cells. If the end result of the formula has a total of 25, that means that the entire range is blank.

=countblank(C1:AA1)

What I want to do is delete all of the rows where the total = 25.

1 25

2 20

3 10

4 25

5 15

6 25

I want to delete row 1, 4 and 6.

Am having a hard time writing the macro or formula.

Can I make a formula that says if A15 = 25 then delete A15? or add to the existing formula?

=countblank(C1:AA1) if 25 delete row

Any help would be greatly appreciated!

Thanks