Finding Blank cells and inserting a number

[skate1991]

Hi

I was just wondering if anyone knew a formula for finding the blanks in a range of cells and to insert a 0.

Please see an attached example thanks

Thanks

[tom1977]

You can select your range then press F5 - choose special - mark "empty cells" then put 0 and confirm this CTRL + ENTER

[Jack in the UK]

Its impossible to write a correct function (UDF) to add a zero in the empty cell (that is it would be bad practice, not impossible i mean, just to clear that up). The reason is functions return results / values they do not by definition take actions which is what add a zero is.

So you need a procedure to pars the function and evaluate the result / value and then the procedure take the action of adding a zero

In real life this is nonsense and people do all sorts of things good bad and ugly. Thats why Jacks codes are broken in to different routines and should be easy to edit

so if you want VBA scripts to find the cell

Please Login or Register  to view this content.

but hang of that the magic bit bit not really much use so ... this code will add zeros to all blanks in the range top to bottom and is flexable

Please Login or Register  to view this content.