title: Create folders using 2 column values from Excel
body: <p>So I need to make a whole bunch of folders from a spreadsheet.
  I have in column A the Surname and in Column B the name of a person, I need to generate folders based on this.</p>
  <p>I have <a href="https://stackoverflow.com/questions/44711430/create-folders-using-values-from-excel/66106770#66106770">found a bit of code that someone else posted</a>, that works, but I need to add a space between the name and surname in the created folder.
  The original poster said that they did manage to add a space, but never indicated how.</p>
  <pre><code>Sub MakeFoldersForEachRow()
  Dim Rng As Range
  Dim maxRows, maxCols, r, c As Integer
  Dim s As String
  Set Rng = Selection
  maxRows = Rng.Rows.Count
  maxCols = Rng.Columns.Count
  For r = 1 To maxRows
      s = &quot;&quot;
      For c = 1 To maxCols
          s = s &amp; Rng(r, c)
      Next c
      If Len(Dir(ActiveWorkbook.Path &amp; &quot;\&quot; &amp; s, vbDirectory)) = 0 Then
          MkDir (ActiveWorkbook.Path &amp; &quot;\&quot; &amp; s)
          On Error Resume Next
      End If
  Next r
  </code></pre>
  <p>End Sub</p>