title: Excel 2010 VBA Range doesn't select correct data out of a named table
body: <p>I try to select multiple columns out of a named range. I build the string what should be selected with some variables:</p>
  
  <pre><code>Dim onecolumn as Integer, lastcolumn as Integer
  Dim tblTable as ListObject
  Dim strforrange as String
  
  Set tblTable = Sheet1.ListObjects("Table1")
  onecolumn = 3
  lastcolumn = tblTable.Range.Columns.Count 
  
  strforrange = tblTable &amp; "[[#All],[Column" &amp; onecolumn &amp; "]:[Column" &amp; lastcolumn - 1 &amp; "]]"
  
  Range(strforrange).Select
  </code></pre>
  
  <p>I ran the code step-by-step and checked the "strforrange" variable. Even when it's correct the selected columns differ from the ones stated in the string.</p>
  
  <p>Is there any other way to get the range of a named table or does someone know a solution for this?</p>