I have a small range of cells say E4:E8 that I named myRange
As one group I formatted the cells to be of type Number
with no initial values stored in the cells.

I use a " For Each Cell in myRange" loop to cycle through these
cells and look at their contents via the watch window.

The first couple of cells have their value set to " " (a space), and their
Value2 =
" ", (a space), and their Text = " ", again a space

The next cells have their value set to nothing? and their value2 = Empty
and their Text = "" (not a space).

Why this difference? I have done nothing with any of the cells other than
cycle through them, looking at their values.
--
j.f.dolan