| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sets of Characters in Excel VBA
Hi, I want to compare a single character to see if it is one of severa characters. eg 1 to 9. I thought VBA supported sets ? ie Assuming MyString is 1 charcter in length, Instead of doing this: If MyString = "1" or MyString = "2" or MyString = "3" etc..... The ... Can I do: If MyString = {1..9} Then .... Excel VBA doesn't like the curly bracket, it spits any error. Does anyone know how to compare of value to a set or list like this ? Thanks in Advance for any help. Craig -- aussie_crai ----------------------------------------------------------------------- aussie_craig's Profile: http://www.excelforum.com/member.php...fo&userid=1549 View this thread: http://www.excelforum.com/showthread.php?threadid=27071 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if, then, else with Excel 2007 icon sets | Excel Discussion (Misc queries) | |||
| 2 sets of =if strings in excel 2007 | Excel Discussion (Misc queries) | |||
| Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
| In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
| anyway to go with excel two sets of data | Charts and Charting in Excel | |||
Threaded Mode
