| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
String or integer?
How can you test if a value is a string or integer?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
String or integer?
ISNUMBER(value)
ISTEXT(value) worksheetfunction.isnumber(Range("a2")) or worksheetfunction.isnumber(Range("a2")) depending on if you want true or false -- Gary "JustinP" wrote in message ups.com... How can you test if a value is a string or integer? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
String or integer?
IsNumeric(x)
If you need something more exact, perhaps use VarType (see help for more details). "JustinP" wrote: How can you test if a value is a string or integer? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding an integer to a string in code | Excel Programming | |||
| Compare string with integer | Excel Programming | |||
| Concatenating a string and an integer | Excel Programming | |||
| Concatenate two variables (String & Integer) | Excel Programming | |||
| ListBox2.AddItem ListBox1.Value becomes a String when being Integer? | Excel Programming | |||
Linear Mode
