Indirect question
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 |
Indirect question
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 |
Indirect question
"Bernie Deitrick" <deitbe @ consumer dot org wrote In CB4, enter the formula =INDEX(INDIRECT("$BL:$BL"),ROW()) and copy down. Perfect Thank you |
All times are GMT +1. The time now is 12:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com