ExcelBanter - How can I display a result as a cell name?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I display a result as a cell name? (https://www.excelbanter.com/excel-discussion-misc-queries/12688-how-can-i-display-result-cell-name.html)

LouC

How can I display a result as a cell name?

galimi

=CELL("Address",B1)

Replace B1 with the cell reference for which you are obtaining

http://HelpExcel.com

"LouC" wrote:

All times are GMT +1. The time now is 03:35 PM.