| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Equivalent Of VAL
In VBA two cells containing alphanumeric strings like "123abc" can b subjected to evaluation via the use of VAL. Thus, with "97asd" in A 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 an VALUE Worksheetfunctions failed me in this regard. =N(A1)-N(A2) -- 0 while VALUE(A1)-VALUE(A2) -- #NAME error -- david ----------------------------------------------------------------------- davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064 View this thread: http://www.excelforum.com/showthread.php?threadid=39057 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function Equivalent need | Excel Worksheet Functions | |||
| Equivalent of Alt+Tab for going between worksheets? | Excel Discussion (Misc queries) | |||
| equivalent for function , please for help | Excel Worksheet Functions | |||
| Lotus Equivalent | Excel Discussion (Misc queries) | |||
| VBA equivalent of findstr | Excel Programming | |||
Threaded Mode
