Function that returns name of a tab

[KennyG2000]

Is there a function in Excel that returns the name of the current worksheet?
something like: ReturnTabName()?

I looked up the informational and lookup functions in Excel Help and could not find any.

Thanks in advance! /Kenny

 

[VoG]

The workbook must be saved for this to work:

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

 

[KennyG2000]

Worked like a charm. Thanks so much!

 

[Smitty]

Welcome to the Board!

You could also use something like this:

<font face=Calibri><SPAN style="color:#00007F">Function</SPAN> MySheetName(ref) <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">String</SPAN><br>    Application.Volatile<br>    MySheetName = ref.Parent.Name<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Function</SPAN></FONT>

HTH,