There is no worksheet equivalent. You could write your own custom
function:

Function Val(S As String) As Variant
Val = VBA.Val(S)
End Function

Then, call this function from your worksheet cells.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"davidm"
wrote in message
...

In VBA two cells containing alphanumeric strings like "123abc"
can be
subjected to evaluation via the use of VAL. Thus, with "97asd"
in A1
and "54jkm" in A2,
Val(Range("a1"))-Val(Range("a2")) yields 43 ~ (97 minus 23).

Is there a Worksheetfunction that perfoms such role? Both the
N and
VALUE
Worksheetfunctions failed me in this regard.

=N(A1)-N(A2) -- 0 while VALUE(A1)-VALUE(A2) -- #NAME error.


--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread:
http://www.excelforum.com/showthread...hreadid=390579