| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 9495 | 2001-05-30 21:35:00 | Excel | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 13408 | 2001-05-30 21:35:00 | Is there a function which will return the name of the current Worksheet (not the filename)? Thanks |
Guest (0) | ||
| 13409 | 2001-05-31 03:07:00 | When you say return, do you mean show the worksheet name at the bottom/top when printed/saved? If so, go view/header and footer then whereever you want it to show add &[Tab] |
Guest (0) | ||
| 13410 | 2001-05-31 03:53:00 | No! I want a cell to return the name of the worksheet which it is on. i.e. if the worksheet is 'Sheet1' then I want a formula that when entered in a cell on that worksheet returns the value 'Sheet1'. | Guest (0) | ||
| 13411 | 2001-06-03 12:40:00 | If you enter this exact expression, i.e. with quotes and the actual word filename =INFO('filename') it returns e.g.C:\My Documents\[Book1a.xls]Sheet1 showing path, filename and current sheet. (HELP does not indicate it will return all this - maybe it is version dependent. Mine is Excel 97-SR 1) Accordingly, this mess will give you your answer: =RIGHT(CELL('filename',A1),LEN(CELL('filename',A1) )-FIND(']',CELL('filename',A1))) The 'A1' in this formula can be any cell that's not referring to another sheet or another workbook. |
Guest (0) | ||
| 1 | |||||