Suppose cells A1 and A2 contain the start row and start column of a
given range and cells B1 and B2 contain the end row and end column of
this range, my rather awkward solution to constructing a range address
that I can use in a formula is:

= INDIRECT(Address(A2,A1) & ":" & Address(B2,B1))

Is there a more elegant way to set this up?

Thanks!
K