Macro to create directories...

[ad1234]

I want to create a set of directories from a list of student names in a single column, one directory per student e.g.

DirName
Student1
Student2
Student3
Student4
Student5
Student...... up to say
Student130

I've tried scripts in PowerShell but I want to do this in Excel for user friendliness... any help gratefully received...

Ad1234

 

[VoG]

Perhaps like this

Sub MDIR()
Dim LR As Long, i As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LR
    MkDir "C:\" & Range("A" & i).Value
Next i
End Sub

 

[ad1234]

Brilliant - many thanks!

Ad1234