title: Excel VBA Object Required Error
body: <p>I have been looking at this code and can't seem to figure out why I keep getting an object required error. I am trying to add a new sheet, place and array and range in the sheet (this works). Next I want to name all of the cells on the sheet a variable name to be used later. Can anyone see why it's not working? </p>
  
  <pre><code>    Set WS_Temp = Sheets.Add
  With WS_Temp
      .Range(Cells(1, 1), Cells(1, LastColRA)) = Sheet1.Range("Dynamic_Range").Value
      .Range(Cells(2, 1), Cells(counter + 1, LastColRA)) = Application.Transpose(vList)
      '.Range(Cells(1, 1), Cells(counter + 1, LastColRA)) = Selected_Range
      '.Range(Selection, Selection.SpecialCells(xlLastCell)).Select = Selected_Range
  End With
  
  Set Selected_Range = WS_Temp.Range(Selection, Selection.SpecialCells(xlLastCell)).Value ***ERRORS HERE 
  </code></pre>