"Excel VBA Help" |
|
|
)
|
|
|||||||||
| Microsoft Excel Forum Members Post questions in this forum if they are related to using Microsoft Excel, this includes Worksheet Functions, Excel VBA Programming, Simple Macro Code & Charting, Excel formula etc. |
| New Reply |
|
|
LinkBack | Thread Tools | Rate Thread | Display Modes |
18th September 2009, 23:54
|
||||
|
||||
Test for alpha char
Excel: VBA
I'm trying to test a string for alpha chars, if alpha char append char to a new string The following does not work. Is there a tweak I can apply? l_Alpha_chars = "abcd1" For q = 1 To Len(l_Alpha_chars) l_chr = Mid(l_Alpha_chars, q, 1) If l_chr = [a..z] Then NewStr = NewStr & l_chr End If Next q |
| The Code Cage Advertisment | ||
| ||
|
19th September 2009, 00:42
|
||||
|
||||
Re: Test for alpha char
Warning
|
|
19th September 2009, 00:42
|
||||
|
||||
Re: Test for alpha char
Warning
|
| The Code Cage Advertisment | ||
| ||
|
19th September 2009, 04:54
|
||||
|
||||
Re: Test for alpha char
Warning
|
|
19th September 2009, 12:11
|
||||
|
||||
Re: Test for alpha char
Warning
|
|
19th September 2009, 17:32
|
||||
|
||||
Re: Test for alpha char
Warning
|
| The Code Cage Advertisment | ||
| ||
|
To stop seeing these ads and get other benefits check This page! |
|
19th September 2009, 17:32
|
||||
|
||||
Re: Test for alpha char
Warning
|
|
19th September 2009, 19:13
|
||||
|
||||
Re: Test for alpha char
Warning
|
| The Code Cage Advertisment | ||
| ||
|
| New Reply |
| Tags |
| alpha, char, test |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
The Code Cage Affilliates
|
Linear Mode
