| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to test variable for chr values
Hi Smartin
not sure if I totally get the question I think you got the question. I had forgotten about instr. And it seems to be working. Also, why so many chr() instead of plain text? chr(67) chr(65) chr(68) chr(45) chr(82) is just strings C A D - R I'm converting this from formulas, and that's the way the formulas were set up. I changed it as you showed in your example. Thanks, Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I test if a variable is a member of an array | Excel Programming | |||
| how to test whether selected variable is within defined range | Excel Programming | |||
| Logical test as a variable in a UDF | Excel Programming | |||
| How to test if a workbook variable is valid | Excel Programming | |||
| test for not blank, use value in cell and set as variable | Excel Discussion (Misc queries) | |||
Threaded Mode
