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).
 
You must log in or register to reply here.

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

Similar Threads

a string to an integer 11
Concatenating a string and an integer 2
convert string to integer 7
Compare string with integer 2
String to Rounded Integer 3
Using strings, integers and stuff 2
adding an integer to a string in code 2
convert constant string to integer 7

Top