ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Spreadsheet name in a Cell (https://www.excelbanter.com/excel-discussion-misc-queries/40589-spreadsheet-name-cell.html)

Alain79

Spreadsheet name in a Cell
 
I am looking for a cell formula that would recover the spreadsheet name and
display it in a cell - more or less as "=CELL("row";A1) function is able to
return the line number of cell A1 or as "=CELL("filename";C18)" will return
the full path of the Excel workbook housing cell C18...

Thanks a lot - Alain79



Bob Phillips

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob Phillips

"Alain79" wrote in message
...
I am looking for a cell formula that would recover the spreadsheet name

and
display it in a cell - more or less as "=CELL("row";A1) function is able

to
return the line number of cell A1 or as "=CELL("filename";C18)" will

return
the full path of the Excel workbook housing cell C18...

Thanks a lot - Alain79






All times are GMT +1. The time now is 02:18 AM.

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