Thread: How can I create five folders after this with a spacific name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default How can I create five folders after this with a spacific name
Sub tryme()
For Each mycell In Range("C3:C6")
MkDir "C:\" & mycell.Value
Next
End Sub

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"David Shoemaker" wrote in
message ...
MkDir "C:\" & Range("C3").Value

Example: C:\12345\ART, LG1, G-CODE, LG3, LR2


Reply With QuoteReply With Quote