Visual Basic Excel How do I determine if cell is numeric or text
D Dave Peterson Mar 7, 2009 #2 msgbox isnumeric(somecell.value) but VBA's isnumeric() will accept anything that looks like it could be a number. If you want to use excel's test =isnumber() in a worksheet formula, you could use: msgbox application.isnumber(somecell.value)
msgbox isnumeric(somecell.value) but VBA's isnumeric() will accept anything that looks like it could be a number. If you want to use excel's test =isnumber() in a worksheet formula, you could use: msgbox application.isnumber(somecell.value)
