See also the VBA help for MkDir

MkDir "C:\" & Sheets("Sheet1").Range("A1").Value



--
Regards Ron de Bruin
http://www.rondebruin.nl



wrote in message oups.com...
Hi all:

How do I write a VBA code in excel to add a folder on the c:\ from the
contents in cell A1.

For example, if cell A1 has Look, how could I write code that makes a
folder on the c:\ drive that is c:\look.

Any help is greatly appreciated. Cheers.

~Matt