See if this works for you:

Instead of Find/Replace....

Select the range containing the blank cells you want impacted
<edit<goto
Click the [special cells] button
Check: Blanks
Click the [OK] button

That will select the blank cells in that range.

Press the [F2] key to begin editing the active cell.
Enter the formula, being mindful of the workings of relative references

Then...Hold down the [ctrl] key and press [enter]
That will put the formula in each blank

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Alvin" wrote:

I am trying to repalce all blank cells with a formula but I cannot seem to
figure out how to enter the replace with my formula?