Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sets of Characters in Excel VBA
Thanks everyone, for your advice. The "Like" operator is excellent and makes my code much more readabl - I'm sure you all know this - but just in case, the following works: I wanted my test to return TRUE if the character was "0" to "9" or "." While MyString Like "[0-9,.]" sure beats While MyString = "0" or MyString = "1" or MyString = "2" ....... etc So once again, thanks for you help. You make life a lot easier -- 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sets of Characters in Excel VBA
You are matching a comma as well. Was that intended?
On Wed, 20 Oct 2004 20:57:27 -0500, aussie_craig wrote: Thanks everyone, for your advice. The "Like" operator is excellent and makes my code much more readable - I'm sure you all know this - but just in case, the following works: I wanted my test to return TRUE if the character was "0" to "9" or "." While MyString Like "[0-9,.]" sure beats While MyString = "0" or MyString = "1" or MyString = "2" ........ etc So once again, thanks for you help. You make life a lot easier. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
Sets of Characters in Excel VBA | Excel Programming | |||
Sets of Characters in Excel VBA | Excel Programming |