Thread: TypeName function
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
ArthurJ ArthurJ is offline
external usenet poster
  
Posts: 32
Default TypeName function


"Peter T" wrote:

Try
MsgBox (LCase(TypeName(ActiveCell.Value)) = "string")

or of course simply change "string" to "String"

For this kind of test I would use

MsgBox VarType(ActiveCell.Value) = vbString

Regards,
Peter T

Thanks for the suggestion to use the VarType function. Unlike IsNumeric it identifies a string that looks like a number (ie, with a leading apostrophe). VarType is exactly what I needed.

Art
Reply With QuoteReply With Quote