Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For loop with letters
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
For loop with letters
One way:
Dim i As Integer Dim sFileName As String For i = 1 To 26 'Debug.Print Chr(i + 64) sFileName = Chr(i + 64) Kill sFileName Next 'i or just: For i = 1 To 26 Kill Chr(i + 64) Next 'i Regards Trevor wrote in message oups.com... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Formating Letters to Numbers while Displaying Letters | Excel Worksheet Functions | |||
Columns now numbers rather than letters how do i get letters back | Excel Discussion (Misc queries) | |||
Count only Letters in cells that contain both letters and numbers | Excel Worksheet Functions | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
change lower letters to upper letters | Excel Discussion (Misc queries) |