Clear a column when true

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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!
 
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
 
Back
Top