View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default 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.