dim i&
for i = 65 to 77
strletter = chr$(i)
msgbox strletter
next
--
keepITcool
|
www.XLsupport.com | keepITcool chello nl | amsterdam
Dr.Schwartz wrote :
I have a variable (DIM strLetter as string) that should change from A
to X (24 letters) using the same order as the alphabet.
Any suggestions to how I can set this up in my code? Functionality
I'm looking for:
DIM strLetter as string
For strLetter = A to X
Msgbox("strLetter is now: " & strLetter)
next strLetter
Thank you
The Doctor