String or integer?

G

Gary Keramidas

ISNUMBER(value)

ISTEXT(value)

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

depending on if you want true or false
 
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

Similar Threads

a string to an integer 11
Using String as Code for new Module 1
String to Rounded Integer 3
display a file in excel by using vba 0
convert constant string to integer 7
Datavalidation with shrinking non blank values 1
PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
VBA code in one Module referencing Public Variables Declared inanother Module failing 5

Top