Formula to capture worksheet names

[LowKey]

I am looking for a formula that will allow me to capture the name of one
worksheet in a specific cell of another worksheet. All sheets are in
the same workbook.

Thanks in advance for any help
LowKey

 

[firefytr]

Hello,

This will help ...


http://www.vbaexpress.com/kb/getarticle.php?kb_id=213


An example can be found there for download also.

You can use it like ...


=ShName(Sheet2!A1)
(set the cell reference {optional} to any valid cell reference)

or

=ShName()
(this will give you the sheet name which holds the formula)


HT