Checking for empty

[tiredofit]

I check for emptiness by typing this into the immediate window:

?IsEmpty(Sheet1.Cells(1,1).Value)

and it returns False

But when I type:

?Len(Sheet1.Cells(1,1).Value

I get a value of 0!

Can someone tell me what is going on?

Is the worksheet corrupt?

 

[tiredofit]

What about

=UNICODE(G1)

same results as =CODE.

 

[Fluff]

If you select the cell & look in the formula bar, do you see anything?

 

[tiredofit]

If you select the cell & look in the formula bar, do you see anything?

Nothing

 

[Fluff]

Odd, as both is blank reports False & using Ctrl right arrow stops at G1, there has to be something there, but not sure what.

 

[tiredofit]

I agree but can't see anything.

Another Excel quirk is all I can say.

LEN(G1) returns 0 too.

 

[Fluff]

In that case it's probably a Null String. If you type this in the immediate window & hit enter does is blank become true

[g1].value=[g1].value

 

[tiredofit]

On the Sheet, =ISBLANK(G1) showed FALSE. (This is cell G3).

When I typed:

[g1].value=[g1].value

and pressed return, the immediate window didn't show anything but cell G3 now showed TRUE.

 

[Fluff]

In that case it was a nullstring.

 

[tiredofit]

In that case it was a nullstring.

which is the same as empty?

 

[Fluff]

No it's not.