View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roman Töngi Roman Töngi is offline
external usenet poster
 
Posts: 6
Default if char is number

How can I determine whether a char is a digit or a period by menas of VBA?
Example:
If char = 0 or char = 1 ... or char = 9 or char = "." Then
...

There is sure to be a shorter solution.

Regards,
Roman