View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 66
Default 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?