String or integer?

[JustinP]

How can you test if a value is a string or integer?

 

[Gary Keramidas]

ISNUMBER(value)

ISTEXT(value)

worksheetfunction.isnumber(Range("a2"))
or
worksheetfunction.isnumber(Range("a2"))

depending on if you want true or false

 

[Guest]

IsNumeric(x)

If you need something more exact, perhaps use VarType (see help for more
details).