Create folders from list in column

[saybut]

Hi, is there any way to create a list of folders from names in
column?

I have a list of names in column A and I want to create a series o
folders with them being named as in column A.

I have a folder C:\Out\ on the C drive and I need to create the folder
in there.

Any help would be greatly appreciated.

Regards,

Mark Pitchford

 

[Ron de Bruin]

Hi saybut

Try this one

Sub test()
ChDir "c:\Out"
For Each cell In Range("A1:A10").SpecialCells(xlCellTypeConstants)
MkDir "c:\Out\" & cell.Value
Next
End Sub

 

[saybut]

Hi,

Many Thanks, it works perfectly.

Regards,

Mark P