Take a look at the MkDir method in VBA Help.

Const sPATH As String = "C:/Program Files/"
MkDir sPath & Range("A1").Value


In article ,
rsabot wrote:

I need to create a new folder using a folder name in a given cell (ex: A1).
Can I create a macro that will make the new folder (ex: c:/program files/A1)?

thanks in advance