G Gary Keramidas Sep 5, 2006 #2 ISNUMBER(value) ISTEXT(value) worksheetfunction.isnumber(Range("a2")) or worksheetfunction.isnumber(Range("a2")) depending on if you want true or false
ISNUMBER(value) ISTEXT(value) worksheetfunction.isnumber(Range("a2")) or worksheetfunction.isnumber(Range("a2")) depending on if you want true or false
G Guest Sep 5, 2006 #3 IsNumeric(x) If you need something more exact, perhaps use VarType (see help for more details).