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).
 

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

Back
Top