ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using the results of CELL function ("address" info type) (https://www.excelbanter.com/excel-programming/309245-re-using-results-cell-function-address-info-type.html)

Frank Kabel

Using the results of CELL function ("address" info type)
 
Hi
use INDIRECT for this

--
Regards
Frank Kabel
Frankfurt, Germany


Mike D wrote:
I would like to use the results of the CELL function ("address" info
type) as part of a range in another formula to allow me to flex the
starting and/or ending point of a range for another function (i.e.,
SUM).



All times are GMT +1. The time now is 04:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com