String or integer?

  • Thread starter Thread starter JustinP
  • Start date Start date
ISNUMBER(value)

ISTEXT(value)

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

depending on if you want true or false
 
IsNumeric(x)

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