| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell names = sheet names
The following formula works great if you want the cell name to be the current
sheet. =MID(CELL("filename",a1),SEARCH("]",CELL("filename",a1))+1,1024) Is there a way to reference a different sheet? For example is there a way for Sheet 1 Cell B3 to show the name of Sheet 3? Thanks for you help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| list sheet names vertically below the active cell - need macro. | Excel Worksheet Functions | |||
| Sheet names linking to cell | Excel Discussion (Misc queries) | |||
| How can I make the names for Sheet tabs a reference to a cell? | Excel Discussion (Misc queries) | |||
| Concatenating cell values to create sheet names | Excel Discussion (Misc queries) | |||
| Sheet Names and Cell References | Excel Worksheet Functions | |||
Threaded Mode
