title: Loop through the first column of a table range in Excel using VBA
body: <p>This should be pretty straightforward but I'm a little stuck.</p>
  
  <p>I have a table called "ClientReturns" in a worksheet. The first column of this table contains the account number of a client.</p>
  
  <p>I want to loop through the table getting the account number each time. This is what I have so far but it also goes through the data in the other columns when I only want the data in the first column.</p>
  
  <pre><code>Sub doStuff()
  
      Set ClientTable = Sheets("Returns").range("ClientReturns")
      For Each tRow In ClientTable
          AccNum = tRow.Columns(1).Value
          'Do stuff with the account num
      Next AccNum
  
  End Sub
  </code></pre>
  
  <p>Many thanks for the answers... I solved it with this:</p>
  
  <pre><code>Sub getReturns()
  
      Dim lookR As range, c As range
      With Sheets("Returns").ListObjects("ClientReturns")
          Set lookR = .ListColumns("Account Number").DataBodyRange
          For Each AccNum In lookR.Cells
              'Let's see if it's a combined account
          Next AccNum
      End With
  
  End Sub
  </code></pre>