Forum Discussion
Solved
Capture sheet name
When using the referencing or lookup functions, I frequently need to "capture" the name of a sheet. The function "Sheet" returns only the number of the sheet, even though a http://www.excelfunctions...
That's only VBA or parse result of the
=CELL("filename",<cell>)
Hi Sergei
Of course, you're right. there is nothing wrong with the example.
Anyone else that know of a function that reveals the sheet name?
That's only VBA or parse result of the
=CELL("filename",<cell>)
Thanks. I'll try that.