title: VBA for TableStyle
body: <p>I have tried to alter the default table style to TableStyleLight9 but my code won't accept it.  Can you please educate me on how to do so?  This is how I set my table up....also would you know why this method places my drop down menu outside the confines of the table?</p>
  
  <p>Thank-you.</p>
  
  <pre><code>FinalRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row
  LastColumn = Cells(1, Columns.Count).End(xlToLeft).Column
  
  ActiveSheet.ListObjects.Add(xlSrcRange, Range(Cells(1, 1), Cells(FinalRow, LastColumn)), , xlYes).Name = "Data"
  </code></pre>