Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Loop an alphabet
- Thread starter ASPVBNerd
- Start date
HarleyQuinn
Programmer
A simplish way would be to use:
The Chr function used this way converts the the ascii values of the letters (which start at 97 for the lower case, hence the + 96) into the letters.
Hope this helps
HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.
Code:
For i = 1 To 26
Debug.Print i & Chr(i + 96)
NextHope this helps
HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.
HarleyQuinn
Programmer
Too fast for me there George... ![[smile]](/data/assets/smilies/smile.gif "[smile] [smile]")
HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.
HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.
![[wink]](/data/assets/smilies/wink.gif "[wink] [wink]")
- Thread starter
- #6
HarleyQuinn
Programmer
HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.
- Status
Similar threads
- Locked
- Question