MkDir "C:\" & Range("C3").Value Example: C:\12345\ART, LG1, G-CODE, LG3, LR2
D David Shoemaker Nov 12, 2008 #1 MkDir "C:\" & Range("C3").Value Example: C:\12345\ART, LG1, G-CODE, LG3, LR2
B Bernard Liengme Nov 12, 2008 #2 Sub tryme() For Each mycell In Range("C3:C6") MkDir "C:\" & mycell.Value Next End Sub best wishes