ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Clear a column when true (https://www.excelbanter.com/new-users-excel/164478-clear-column-when-true.html)

Jeff[_9_]

Clear a column when true
 
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

Clear a column when true
 
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!




All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com