Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to get the name of the sheet in a cell?
Hello, I would like to know if there's a function or a macro to put the name of the current sheet in a cell like ="this sheet is called"&<function that returns the name of the sheet so that if a sheet's name is "kaput" it should appear "this sheet is called kaput" Tks Alexandra -- Alexandra ------------------------------------------------------------------------ Alexandra's Profile: http://www.excelforum.com/member.php...o&userid=26707 View this thread: http://www.excelforum.com/showthread...hreadid=399701 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
Chart Title or Text Box Linked to cell & sheet | Charts and Charting in Excel | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Same cell added to master summary sheet | Excel Worksheet Functions | |||
referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions |