Clear a column when true

[Jeff]

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!

 

[Gord Dibben]

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 special>values so the cell is no longer
dependent upon another cell or range which you can delete.


Gord Dibben MS Excel MVP