Code to get worksheet name into a cell

[Hydestone]

Is it possible to have the worksheet name autopopulate into a cell?

Example - I want the sheet name to appear in cell F1. Is that possible? Also, if I rename Sheet 1 to 12345, the info in cell F1 would change from Sheet 1 to 12345.

 

[kweaver]

You shouldn't have to close and reopen it. However, you will probably have to recalculate the sheet to run the CELL("filename"...) again.

 

[Kamolga]

For some reason, when I copy the worksheet which is using the reference above, the new worksheet displays #VALUE in the cell, instead of the sheet name. If I save the file, it still says #VALUE . If I save, close, and reopen - the formula then works and the cell shows the worksheet name. Any way to get the sheet name to show without closing and reopening the workbook?

You just need to save as since the formula is based on filename, then any calculation will update the value.