Define range based on the values in another cells

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?

Please Login or Register  to view this content.

So cell H3 contains the text M6 and I3 contains the text T6.

So in this case the code should select range M6:T6

Thanks! Brilliant!