I've looked on different forums and I found posts of people that want to define a range based on only the amount of rows of the ending cell of the range.

I'm trying to define a range based on complete cell references for the beginning and the end of the range filled in in different cells.

For example, cell H3 says that range will start at M6 and cell I3 says that the range will end at T7.

The code I've written I've added below but errors out.

Does anyone know how I can best do this?

  
Sub getRng()
    Dim Cval1 As Variant
    Dim Cval2 As Variant
    Dim Rng As Range
        Cval1 = ActiveSheet.Range("H3").Value
        Cval2 = ActiveSheet.Range("I3").Value
        Set Rng = ActiveSheet.Range("Cval1:Cval2")
End Sub