Function Val("1") not working

[mtheriault2000]

Simple code to transfer a string number to a number as long is not working.

Dim v as long
v= val("12")

 

[mtheriault2000]

Thanks Rorya, Norie

Did found the reason of the nonfunctional "VAL"

Somewhere in my code, I had define a variable

Public Val as Integer

That was the source of the problem
Strange that the name Val for a variable as been accepted by Excel, but now I understand why....

Martin

 

[xenou]

^^ Making a mental note to remember that. I've seen that before and forgot conflicting variable identifiers is another reason for this kind of thing to occur. Good detective work.