one way is something like this:

Sub test()
Dim i As Integer
For i = Asc("a") To Asc("z")
Debug.Print Chr(i)
Next i
End Sub


--
Hope that helps.

Vergel Adriano


"Madiya" wrote:

I need to loop from a to z.
say
for i=a to z
......
next

How can I do it?

Regards,
Madiya