A
Avir
Is it possible to increment a Letter A to B .....and so on till Z through code. Is there a function to increment it
thanks for your help
thanks for your help
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
rkc
code. Is there a function to increment it?Avir said:Is it possible to increment a Letter A to B .....and so on till Z through
thanks for your help.
How about Chr$(Asc(someLetter) +1) keeping in mind that A to Z = 65 to 90?
B
Byron
The following code will assign a starting Character (A)
to a string variable, then increment it to the next
character (B). Keep in mind that this is case sensative,
so what ever character you start with this will produce
the next character. You will need to check for the "Z =
90" and take appropriate action.
Dim strStartVal As String
Dim strNewVal As String
strStartVal = "A"
strNewVal = Chr(Asc(strStartVal) + 1)
HTH
Byron
it?
to a string variable, then increment it to the next
character (B). Keep in mind that this is case sensative,
so what ever character you start with this will produce
the next character. You will need to check for the "Z =
90" and take appropriate action.
Dim strStartVal As String
Dim strNewVal As String
strStartVal = "A"
strNewVal = Chr(Asc(strStartVal) + 1)
HTH
Byron
on till Z through code. Is there a function to increment-----Original Message-----
Is it possible to increment a Letter A to B .....and so
it?
A
Avir
Thanks Byro
It works great!
It works great!