Why would you want each cell to a <space charater in it?

But here's a macro.

Sub foo()
Dim cel As Range
For Each cel In Selection
cel.Value = " "
Next cel
End Sub


Gord Dibben MS Excel MVP

On Thu, 23 Aug 2007 23:01:38 GMT, "Emerogork" <u36894@uwe wrote:

Is it possible to clear all values in a range of cells and have a "space"
value entered. I have seen that I can assign a macro to a button. Can this
be done in Excel 2003?

Emerogork