How to create a Range with Address()

  • Thread starter Thread starter Steve McLeod
  • Start date Start date
S

Steve McLeod

I can use this formula, =INDIRECT(ADDRESS(10,2)), but I haven't figured out
how to specify a range as in =INDIRECT(ADDRESS(10,2) & ":" & ADDRESS(30,6)).
I can put the range address into a cell and then reference the cell with
INDIRECT, but it would be nice to imbed the range address calculation inside
the INDIRECT function and save the step.
 
Your initial try is actually correct! It's just a matter of using it the
right way. For example:

=SUM(INDIRECT(ADDRESS(1,2) & ":" & ADDRESS(10,10)))

will work just fine
 
The worksheet Address function only handles a single cell.

Are you sure you need that Indirect and Address combination, how about

=OFFSET(A1,10-1,2-1,30-10+1,6-2+1)

Regards,
Peter T
 
Back
Top