ExcelBanter - Constructing a Cell Reference

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Constructing a Cell Reference (https://www.excelbanter.com/excel-worksheet-functions/18485-re-constructing-cell-reference.html)

olasa

Constructing a Cell Reference

Is this what you are looking for?
=INDIRECT("K3") or =INDIRECT("R"&COLUMN()&"C3"),

Ola Sandström

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=355306

All times are GMT +1. The time now is 06:48 PM.