Replace empty cells with a value

[arvada]

I would think this would be easy, but...

I simply want to replace any empty cells in a selected range with a value (lets say a space). I am trying this by using find/replace, but I cant figure out what to 'find'.

Thanks for your help.

 

[KMKfan]

Try leaving the text box blank and just hitting the "Find Next" button. That worked on mine (running Excel 2000).

 

[Smitty]

Welcome to the Board!

How about this:

<font face=Tahoma><SPAN style="color:#00007F">Sub</SPAN> FillBlanks()
    <SPAN style="color:#00007F">Dim</SPAN> c <SPAN style="color:#00007F">As</SPAN> Range
    <SPAN style="color:#00007F">Dim</SPAN> x <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Variant</SPAN>
        x = InputBox("What do you want to replace blanks with?", "Replace Item")
            <SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> c <SPAN style="color:#00007F">In</SPAN> Selection
                <SPAN style="color:#00007F">If</SPAN> c = "" <SPAN style="color:#00007F">Then</SPAN> c = x
            <SPAN style="color:#00007F">Next</SPAN> c
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
</FONT>

Hope that helps,

Smitty

 

[arvada]

Leaving the find box empty was the trick. Thanks to all who answered. I knew there had to be a simple solution.