I want to find something that clears a whole column (or a range in
that column), when a formula is true.

The problem that I see is that if this column is in a range that (for
instance) sums a row whithin the range of the column, the
message"value" appears.

Any suggestions?

Thanks!

Formulas cannot clear a column or range, they can only return values to the cell
in which they reside.

You would need VBA to achieve what you wish.

Note: you can copy a formula then paste specialvalues so the cell is no longer
dependent upon another cell or range which you can delete.


Gord Dibben MS Excel MVP

On Fri, 02 Nov 2007 01:26:37 +0100, Jeff wrote:

I want to find something that clears a whole column (or a range in
that column), when a formula is true.

The problem that I see is that if this column is in a range that (for
instance) sums a row whithin the range of the column, the
message"value" appears.

Any suggestions?

Thanks!