View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default For loop with letters

One mo

Option Explicit
Sub testme01()
Dim iCtr As Long
For iCtr = Asc("A") To Asc("Z")
MsgBox Chr(iCtr)
'Kill pathname:=Chr(iCtr)
Next iCtr
End Sub



wrote:

Does anyone know how to make a do loop with letters?

I.E

For (filename = A to Z)
delete filename
End loop

Thanks in advance.


--

Dave Peterson