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.

"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?

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.

.

Thanks Byron
It works great!