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

If you're sure that you didn't enter a space character in the cells
(e.g., to 'clear' them), then the only other thing I can think of is
that you have a template file (e.g., "Book.xlt") in your startup folder
that has space characters already inserted in those cells.


In article ,
joed wrote:

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.

Well, let's say I thought I was sure I was not putting spaces into any of the
cells.
I was, thanks for the leading me to the answer

---joe
--
j.f.dolan


"JE McGimpsey" wrote:

If you're sure that you didn't enter a space character in the cells
(e.g., to 'clear' them), then the only other thing I can think of is
that you have a template file (e.g., "Book.xlt") in your startup folder
that has space characters already inserted in those cells.


In article ,
joed wrote:

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.