But now you are saying there are no formulae in those cellsoften I will clear a cells value with an if statement
=if(condition) then, "Action","").
If you have a formula in a cell, then the cell cannot be blank (like when nothing is in a cell) because it has something in it... the formula. The only way is to run a macro that looks for cells displaying "" and have that macro physically clear the cell. Of course, that means the formula will no longer be there when you make changes that the now missing formula would have reacted to by displaying something other than "".often I will clear a cells value with an if statement
=if(condition) then, "Action","").
My issue is with the "".
Instead of setting the cell to "" how to I just make it a blank cell?