Alphabet loop

[Everton]

Hello,

I'd like to create a loop that will step through the letters of the alphabet, or part of it, in sequence. My first thought was to create a 1-D array called alpabet containing the letters then use:

For Each letter In alphabet
.....
Next

I'm just wondering if anyone has thoughts on any better ways to do this.

Cheers,
Paul.

 

[Ken Grubb]

Dim i As Integer
For i = 1 To 26
Debug.Print Chr$(i + 64)
Next i

HTH,

Ken Grubb
Burlington, NC, USA

 

[Everton]

Thanks, I think that is certainly a more elegant way.

Paul.