title: Select Row in Excel with VBA if complete
body: <p>I want to select each row that is complete. So each row where there is no empty cell. 
  The selected row should then be exported to a sharepoint list.</p>
  
  <p>so far the code I tried works but exports the whole table. I want to add a line that selects and exports only the rows that have no blank cells.</p>
  
  <p>I had something like the following in mind. But I don't know how to select the complete rows from the entire table instead of specifying the cells.</p>
  
  <p><code>If Cells().Value not isnull then
  Range().EntireColumn.Select</code></p>
  
  <pre><code>Sub ExportToSharePoint ()
      ActiveSheet.ListObjects("Table1").Publish Array("https://sharepoint...", "Name of the List")_, True
  
      ActiveCell.Select   
  End Sub
  </code></pre>