View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
6e 6e is offline
external usenet poster
 
Posts: 1
Default testing for a string type

hi!

Im working with the selection object.

what I would like to do is test to make sure that the object's value is
a string object, and if it isn't I would like to skip some
functionality.

so....

If (Selection.Value IS A STRING") Then ' HELP! how do I
do this?
strFindText = Selection.Value
Else
'nothing, dont change value
End If