Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
How to change numbers in entire spreadsheet from one cell? | Excel Worksheet Functions | |||
How can I replace the path of the linked spreadsheet in a cell? | Excel Worksheet Functions | |||
I need to protect all but one cell in an Excel XP spreadsheet. | Excel Discussion (Misc queries) | |||
Excel should let me circle a cell or number in the spreadsheet fo. | Excel Discussion (Misc queries) |