Tab Name

  • Thread starter Thread starter Martin Schmid
  • Start date Start date
M

Martin Schmid

Is there a simple function to return the sheet/tab name of a worksheet... In
office 2000 I had to use:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
But I believe that there is something more straight forward now, but I don't
remember what it is.
 
No there is not, use the same formula

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Martin,

There is no better way in more recent versions of Excel. Use the
same formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I thought there was a simpler method in OfficeXP... anyone?

--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE
Peo Sjoblom said:
No there is not, use the same formula

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom


Martin Schmid said:
Is there a simple function to return the sheet/tab name of a
Click to expand...
worksheet...
In
office 2000 I had to use:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
But I believe that there is something more straight forward now, but I don't
remember what it is.
Click to expand...
Click to expand...
 
NO, there is no better way. What part of the answer didn't you understand?

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom


Martin Schmid said:
I thought there was a simpler method in OfficeXP... anyone?

--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE
Peo Sjoblom said:
No there is not, use the same formula

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom


Martin Schmid said:
Is there a simple function to return the sheet/tab name of a
Click to expand...
worksheet...
In
office 2000 I had to use:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
But I believe that there is something more straight forward now, but I don't
remember what it is.
Click to expand...
Click to expand...
Click to expand...
 
I thought perhaps you may have misunderstood that I was still on Office
2000. I also misunderstood the part that you were supreme ruler of Excel
knowledge with an ego needing to be fed by pedantic responses.



--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE


Peo Sjoblom said:
NO, there is no better way. What part of the answer didn't you understand?

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom


Martin Schmid said:
I thought there was a simpler method in OfficeXP... anyone?

--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE
Peo Sjoblom said:
No there is not, use the same formula

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom


Is there a simple function to return the sheet/tab name of a worksheet...
In
office 2000 I had to use:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
But I believe that there is something more straight forward now, but I
don't
remember what it is.
Click to expand...
Click to expand...
Click to expand...
 
Martin

Perhaps you were thinking of a UDF?

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

In a cell enter =SheetName()

Gord Dibben Excel MVP
 
Hello Martin.
I also misunderstood the part that you were supreme ruler of Excel
knowledge with an ego needing to be fed by pedantic responses.
Click to expand...

There is no supreme ruler of Excel knowledge. <bg> While Peo is on a
different level compared to most
(http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpaward&style=
toc#faq3068 Office Systems - Excel), I suspect that if he had an ego problem
he'd at least flag up his MVP status in his signature.

Sorry there's no solution to your question, however 9/10 if the answer
exists you can find it here.

Best rgds,
Andy
 
Probably need to lighten up a bit - you've been posting here often
enough to recognize Peo's name and status as an MVP. I doubt he feels
the need to have his ego fed. Look back at your response to first reply
- he gave you a definitive answer to a very frequently asked question.
Your "...anyone?" could easily be read as impugning the competence of
the replyer (not that that's necessarily what you meant).

FWIW, you can find other answers to FAQs here

http://www.contextures.com/xlfaqFun.html

or as was suggested to you back in August'02, by searching the archives

http://groups.google.com/advanced_group_search?q=group:*excel*

And you can get tips on using these groups effectively at

http://cpearson.com/excel/newposte.htm
 
Perhaps that is what I am thinking of... I found sheetname() in my notes,
but a comment that it didn't work in Excel2000...
 
Peo's "NO, there is no better way. What part of the answer didn't you
understand?" was the instigative response. It is as condesending a
middle-school shop teacher's response to unruly teenagers.

Perhaps I find Gord's approach better for my situation....
 
Hi


Martin Schmid said:
Perhaps that is what I am thinking of... I found sheetname() in my notes,
but a comment that it didn't work in Excel2000...
Click to expand...

Of course it didn't. It doesn't work in ExcelXP too, lest you create this
function before. And it will work in Excel2000 too, when you create it -
maybe using different code. UDF desiphers as User Defined Function.
 
Are you sure Peo <g>

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Peo Sjoblom said:
NO, there is no better way. What part of the answer didn't you understand?

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom


Martin Schmid said:
I thought there was a simpler method in OfficeXP... anyone?

--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE
Peo Sjoblom said:
No there is not, use the same formula

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom


Is there a simple function to return the sheet/tab name of a worksheet...
In
office 2000 I had to use:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
But I believe that there is something more straight forward now, but I
don't
remember what it is.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top