Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To: Make cell reference the sheet name
Hi Kevin
try the following formulas - a little more than asked for The sheet name =RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("file name",A1),1)) File path and file name: =CELL("filename",A1) File path only =LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1) File name only =MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CEL L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1) HTH Frank Kevin McCartney wrote: Hi, I'd like a cell to contain the name of the sheet that it is, like the &[TAB] in a footer, any ideas on what function can do this much appriciated. I've looked at INFO function but no help, I know I could do it in code but I don't want to add a module to the report.... get to many questions about, oh your report contains viruses bla, bla. TIA KM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
How To make a sheet reference Variable (eq: sum(sheet!D2:H2)) | Excel Discussion (Misc queries) | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
How can I make the names for Sheet tabs a reference to a cell? | Excel Discussion (Misc queries) | |||
How do I make a cell reference to a sheet title name | Excel Discussion (Misc queries) |