title: Selecting a table of data VBA
body: <p>I am very new to VBA/coding and so I'm in need of some help and so will likely be posting on here quite a bit within the next few weeks. I have been teaching myself as much as I can over the last week or so and I have decided to start a project.</p>
  
  <p>I need to select and copy a table of data but the problem is the table of data changes size every single day so I cannot set a specific range. The code I am using is this but it isn't selecting the whole table.</p>
  
  <pre><code>Workbooks.open "filepath\filename.xls"
  Workbooks ("filename.xls").Activate
  Range ("b8").Select
  Range (Selection, Selection.end(xlDown)).Select
  Range (Selection, Selection.end(xlToRight)).Select
  </code></pre>
  
  <p>The attached picture is the table and the first cell with data in is b8(Target SLA &amp; Category) and I want it to copy down to the bottom right of the image. as i have stated the table changes size each day so I can't have a set range. <a href="http://i.stack.imgur.com/NoYGY.jpg" rel="nofollow">Table Data</a></p>