TYPE function 1

[Luis939]

im having problems using the TYPE function, i went to the help file to see how to use it but i keep getting errors
Cant i use
If TYPE(activecell.value) = 2 then.......

what is the proper syntax to determine whether my value is a string or not?? thanks!

 

[Zathras]

Here is one way:
[blue]

  Sub test()
    If TypeName(ActiveCell.Value) = "String" Then
      MsgBox "Is a string"
    Else
      MsgBox "NOT a string"
    End If
  End Sub

[/color]

 

[Luis939]

Yea Zanthras I went back to the help function, saw the topic on TypeName, and tested it, and it worked, i wonder why it said TYpe would do that and it didnt help me. Thanks alot though, your always a great help!