I only know of a trick formula that will return the value of the sheet the
formula is entered into:

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

What did you have in mind? How would you envision this function working?
What are your requirements?

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"HpyTrvlr69" wrote:

My question is simple.

Does anyone out here know of a function that returns the name of a specific
TAB in a workbook?