| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Testing same cell across multiple sheets for a string and counting each instance? | Excel Worksheet Functions | |||
| Testing a string array for any values | Excel Programming | |||
| Formula to extend a string of type AAA001 | Excel Worksheet Functions | |||
| Variant Array with String Values - Type Mismatch | Excel Programming | |||
| Type mismatch? string 2 a long?? | Excel Programming | |||
Threaded Mode
