Create new folders with VBA

[SoothSailor]

Hi, I'm looking for a way to create some new folders based on cell values. So, If I have a column like this:

Apples

Bananas

Oranges

I would have 3 folders in my H:/ drive labeled "Apples", "Bananas", and "Oranges". The rows will always be the same, but there can be any number of cells with values, so if the sheet looked like this:

Apples

Bananas

Oranges

Grapes

SummerSausage

I would have 5 folders in my H:/ drive labeled "Apples", "Bananas", "Oranges", "Grapes", and "SummerSausage".

Thanks!

[mikeTRON]

http://www.ozgrid.com/forum/showthread.php?t=32259
http://www.ozgrid.com/forum/showthread.php?t=57145
http://www.techonthenet.com/excel/formulas/mkdir.php