Is it possible to increment a Letter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
on till Z through code. Is there a function to increment
it?
 
Back
Top