Nope. I'm certain I'm on the right cell. Still can't get the advertized Excel
functions to work in VBA.





"Dave Peterson" wrote:

Maybe you're on the wrong cell.

You could add a debugging line:

msgbox c.address & vblf & c.value & len(c.value)

To help find the problem cell.

Miaplacidus wrote:

I've got code:

for each c in range ....

If c.value 0 then

DoCode

End If
Next C

This was working fine, but suddenly it is executing Do Code whne c is blank.

What is wrong here.

When I test is Isnumeric returns true
The value returns blank and the length returns zero.

What gives?

--

Dave Peterson