title: Excel/VBA: How do I convert a single row into an array of the cell values
body: <p>I thought this would be simple, but apparently the geniuses at Microsoft think differently.</p>
  <p>I am writing Excel VBA to loop through the rows in an Excel worksheet and for each row (a Range object), I want to extract the cell values as an array. I've done some searching and found some supposed solutions that are not at all intuitive, nor do they work.</p>
  <p>Does anyone have suggestions on how to do this?</p>
  <pre><code>Private Sub Separate_By_DC()
      Dim row_ As Range
      Dim row_str As String
      
      For Each row_ In ActiveSheet.UsedRange.Rows
          Dim arr As Variant
          arr = Row_To_Array(row_)
          Debug.Print UBound(arr) - LBound(arr) + 1
          
          ' row_str = Concat_Row(row_)
          ' Debug.Print row_str
      Next row_
  End Sub
  
  Private Function Row_To_Array(row_ As Range) As Variant
      Row_To_Array = row_.Value
  End Function
  </code></pre>