title: Adding a new table to Excel using macro/VBA
body: <p>I have a macro that inserts a new table in to a range, and names the new table based on another cells value:</p>
  
  <pre><code>Select Code  copy to clipboard
  Sub sbCreatTable()
  Sheet1.ListObjects.Add(xlSrcRange, Range("B1:B3"), , xlYes).Name = Range("a2").Text
  </code></pre>
  
  <p>However the sheet I would like to add the table to, has a range of tables already, all on Row B, so I need the table to be added to the end of these, and inserted on the first empty cell on row B. The code I have will only insert this in a specific range.</p>
  
  <p>Could anybody assist with pointing me in the right direction?</p>