Numerical Data vs Text
"Tom Ogilvy" wrote...
Actually:
? isnumeric("88")
True
? application.IsNumber("88")
False
isnumeric tests if the value can be interpreted as a number. the
worksheetfunction, isnumber tests if it is being stored as a number.
If the OP is testing cell values, wouldn't
VarType(Rng.Value) = vbDouble
be more efficient?
|