TAB name

  • Thread starter Thread starter Laura
  • Start date Start date
One way:

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

or this UDF:

Public Function SheetName(Optional ByVal rng As Range) As String
Application.Volatile
If rng Is Nothing Then Set rng = Application.Caller
SheetName = rng.Parent.Name
End Function
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy a cell from a diferent tab when the tab name is in a cell 2
Cell copying from tab to tab 2
How to refer to tab names? 1
Linking Tab/worksheet names to a worksheet cell 3
tab in a cell 3
TABS formula Is This Possible & How 2
naming worksheet tabs 1
Macro: finding a cell on one worksheet and copying to another worksheet 0

Back
Top