Hi, I want to create a range where the begin and end cells are specified by two other Range variables. For example,

Set r1 = ActiveSheet.Range("C5")
Set r2 = ActiveSheet.Range("E8")

How can I define r3 to contain the range "C5:E8" using these two?

Thanks in advance.