String or integer?


Ad

Advertisements

G

Gary Keramidas

ISNUMBER(value)

ISTEXT(value)

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

depending on if you want true or false
 
Ad

Advertisements

G

Guest

IsNumeric(x)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top