ExcelBanter - Formula that returns the sheetname

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula that returns the sheetname (https://www.excelbanter.com/excel-discussion-misc-queries/44433-formula-returns-sheetname.html)

TimT

Formula that returns the sheetname

Does anyone know of a formula that would return the active sheetname?

David Hepner

http://www.mcgimpsey.com/excel/formu..._function.html

"TimT" wrote:

Does anyone know of a formula that would return the active sheetname?

TimT

Great Link! The formula was

=MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1, 255)

....yeah, like I was gonna figure that one out on my own.

"David Hepner" wrote:

http://www.mcgimpsey.com/excel/formu..._function.html

"TimT" wrote:

Does anyone know of a formula that would return the active sheetname?

All times are GMT +1. The time now is 02:25 AM.