Constructing range address given row and col numbers of boundaries

K

kakofoniks

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
 
B

Bob Phillips

Assuming you have letters in A2 and B2 you can just use

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

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
A

Arvi Laanemets

Hi

Entrer the number of rows/columns in range into B1/B2, and this formula will
do
=OFFSET($A$1,$A$1-1,$A$2-1,$B$1,$B$2)

Arvi Laanemets
 
K

kakofoniks

I have the actual row and column numbers in A1,A2,B1,B2 (returned from
a different formula)..
 
Top