If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is it possible to increment a Letter
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. |
#2
|
|||
|
|||
Is it possible to increment a Letter
"Avir" wrote in message ... 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. How about Chr$(Asc(someLetter) +1) keeping in mind that A to Z = 65 to 90? |
#3
|
|||
|
|||
Is it possible to increment a Letter
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 -----Original Message----- 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. . |
#4
|
|||
|
|||
Is it possible to increment a Letter
Thanks Byron
It works great! |
Thread Tools | |
Display Modes | |
|
|