How do I create a folder for each name in a list of unknown length
T Tom Ogilvy Mar 2, 2004 #2 Dim rng as Range, cell as Range set rng = Range(Range("A1"),Range("A1").End(xldown)) for each cell in rng mkdir "C:\MyFolder\Names\" & cell.Value Next
Dim rng as Range, cell as Range set rng = Range(Range("A1"),Range("A1").End(xldown)) for each cell in rng mkdir "C:\MyFolder\Names\" & cell.Value Next
