I haven't played with 2007 but it looks like a references problems. What
happens if you go to the Immediate window and type in the following and hit
enter?
Debug.Print Val("123ABC")
If you get the same error, it's either a references problem or a bug in A07.
If you don't get an error, you need to look at your code a little closer.
Oh! Val chokes on null values so make sure there aren't any of them.

Signature
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> Hello,
>
[quoted text clipped - 4 lines]
>
> Can someone please help?
Justin - 13 Jul 2006 18:28 GMT
It was the null / blank / zero length string problem. I fixed it by doing a
find / replace but I had some difficulty with that too; it worked eventually
... The problem was that when I do a Find/Replace for "", the first click to
the Find says none found, the second click however works! Ughhh. I have no
idea what made me try the second click - frustration?
Well, the important thing is that your advice in pointing me to the Null
worked. thanks!
> I haven't played with 2007 but it looks like a references problems. What
> happens if you go to the Immediate window and type in the following and hit
[quoted text clipped - 15 lines]
> >
> > Can someone please help?