title: loop through specific columns in table of excel
body: <p>I want to loop through an excel table and mark all rows with a colour where it finds an empty cell. That works.</p>
  
  <p>But I want to specify now the columns where it should only search.
  This is the actual code:</p>
  
  <pre><code>Sub Mark_Empty()
  
  Dim myTable As ListObject
  Dim myArray As Variant
  
  
  Set myTable = ActiveSheet.ListObjects("Table1")
  Set myArray = myTable.DataBodyRange
  
  
  For Each cell In myArray
      If IsEmpty(cell) = True Then cell.EntireRow.Interior.ColorIndex = 4
  Next cell
  
  End Sub
  </code></pre>