![]() |
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! |
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 12:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com