title: How to create a range using row and column number and copy that range?
body: <p>I am trying to create a range based on dynamic row and column number and copy that range and paste it at another range. I am able to get row and column numbers; but not sure how to create a range out of it and use it for Copy method</p>
  
  <pre><code>Sub cut_paste()
      Set TS = ThisWorkbook.Sheets("Table_Schema")
      TS.Activate
      Dim rng As Range`enter code here`
      Dim str As String
      Dim frow As Integer
      Dim lRow As Integer
  
      lRow = Cells(Rows.Count, 1).End(xlUp).Row
      frow = Range("A1").End(xlDown).Row
  
      rng1 = "A" &amp; frow
      rng2 = "H" &amp; lRow
      str = """" &amp; rng1 &amp; ":" &amp; rng2 &amp; """"
  
      ' getting error on below line
      Set rng = Range(str)
      TS.Range(rng).Copy
  End Sub
  </code></pre>