Hi,

How to remove blank rows from a specified range of cells using formula?

Thanks.

Hi,

You cannot remove blank rows using a formula.

You have to perform one of the following actions:
(1) Delete the blank rows (for example, via filtering); or
(2) Sort the column (this will "push" the blank rows to the bottom).

Both of these options can be automated using VBA if necessary.

__________________
Colin

RAD Excel Blog