How to make a Cell in Excel Reference itself -

I have a table containing the risk points column. I want to type a formula to check each cell and To determine if the cell is empty, then make the value of cell 100, and leave the cells current values. The code I'm trying to use (for cell D2) is as follows:

= IF (ISBLANK (D2), 100, D2)

Let me do this There is a problem in the reason of the inability to reference a cell easily and I believe that by putting this formula into the cell, any idea can be overwritten with the present value of cells?

Assume that the processes you want to work with are D2 From D100 . Try this small macro:

  Sub OneHundred () Dim R Range Set R Range Set R = Range ("D2: D100"). Cells.Special Seals (xlCellTypeBlanks) r.Value = 100 End All  

Adjust the range to meet your needs.