title: Looping through cells, building a range in VBA
body: <p>I am looking to loop through cells and build a range for a graph. My main issue is that I cannot figure out how to incorporate the 'i' into the range. Example:</p>
  
  <pre><code>Dim name As String
  Dim newChart as Chart
  Dim i as Integer
  Set newChart = Charts.add    
  
  For i = 1 To 20
  
      accName = Range("C" &amp; i).Value          'I understand why this works. 
  
      With newChart
          .ChartType = xlColumnClustered
          .SeriesCollection.NewSeries     
          .SeriesCollection(1).Name = accName
          .SeriesCollection(1).Values = wb.Worksheets("Summary-Account").Range("E&amp;i:G&amp;i, I&amp;i:K&amp;i, M&amp;i:O&amp;i, Q&amp;i:S&amp;i")          'How can I get this to work?
          .SeriesCollection(1).XValues = wb.Worksheets("Summary-Account").Range("E3:G3, I3:K3, M3:O3, Q3:S3")
      End With
  
      i = i + 1
  
  Loop
  </code></pre>