Thread: String or integer?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
  
Posts: 2,494
Default String or integer?
ISNUMBER(value)

ISTEXT(value)

worksheetfunction.isnumber(Range("a2"))
or
worksheetfunction.isnumber(Range("a2"))

depending on if you want true or false
--


Gary


"JustinP" wrote in message
ups.com...
How can you test if a value is a string or integer?



Reply With QuoteReply With Quote