Clear a column when true

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 02 Nov 2007 01:26 GMT

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!

Reply to this Message

Gord Dibben - 02 Nov 2007 02:30 GMT

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

>I want to find something that clears a whole column (or a range in
>that column), when a formula is true.
[quoted text clipped - 6 lines]
>
>Thanks!

Reply to this Message

Rate this thread: