New sub-folder in Excel using a formula

[Brian Connolly]

I would like to read a cell value then create a Windows folder using the
value in the cell as the folder name

 

[Gary''s Student]

In an arbitrary cell, enter:

C:\brian
and Select that cell. Then run:

Sub stitute()
v = Selection.Value
MkDir v
End Sub