Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I reference a sheet name in a cell as text?
I want to reference a sheet name within the spread sheet itself as text. I
know I can do it in a header/footer using the &[tab] function, but I'm creating a tool that will be seldom printed. Is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I reference a sheet name in a cell as text?
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) In some cell HTH GerryK "Karl Barthel" wrote: I want to reference a sheet name within the spread sheet itself as text. I know I can do it in a header/footer using the &[tab] function, but I'm creating a tool that will be seldom printed. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
if a cell contains certain text, cut and paste to another sheet | Excel Worksheet Functions | |||
Embedding a reference in a cell with normal text. | Excel Worksheet Functions |