I want range ("CB4:CN289") to indirectly reference Range ("BL4:BX289")

As far as I can see I have to enter the indirect command into each cell
individually. Is there an obvious way of mass producing and doing it in one
go?

Many thanks

In CB4, enter the formula

=INDEX(INDIRECT("$BL:$BL"),ROW())

and copy down.

HTH,
Bernie
MS Excel MVP


"teepee" wrote in message ...
I want range ("CB4:CN289") to indirectly reference Range ("BL4:BX289")

As far as I can see I have to enter the indirect command into each cell individually. Is there an
obvious way of mass producing and doing it in one go?

Many thanks

"Bernie Deitrick" <deitbe @ consumer dot org wrote
In CB4, enter the formula

=INDEX(INDIRECT("$BL:$BL"),ROW())

and copy down.

Perfect
Thank you