vba code: create folders based on cell values
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | Sub MakeFolders()Dim Rng As RangeDim maxRows, maxCols, r, c As IntegerSet Rng = SelectionmaxRows = Rng.Rows.CountmaxCols = Rng.Columns.CountFor c = 1 To maxColsr = 1Do While r <= maxRowsIf Len(Dir(ActiveWorkbook.Path & "\" & Rng(r, c), vbDirectory)) = 0 ThenMkDir (ActiveWorkbook.Path & "\" & Rng(r, c))On Error Resume NextEnd Ifr = r + 1LoopNext cEnd Sub |