Tab name into cell

[Guest]

Is there a formula to have the Tab name put into a cell.

I have my Tabs with a date of the end of a pay period for payroll. In the
worksheet, I have in a cell "Pay Period Ending" with the cell beside it being
the same date as the tab.

I want it to automatically have the same date as the tab for when I create
new worksheets and name the tabs.

PLEASE let me know if this is possible.

Thanks!

 

[Paul B]

Texansgal, have a look here,

See http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

You may create an UDF for that. One simple example can be:
Function TabName()
TabName = ActiveSheet.Name
End Function
To add this UDF, open the Visual Basic Editor (Alt+F11), go to
Insert->Module and paste the the code above.

And use it on the cell "Pay Period Ending" with "=TabName()"

Hope this helps,
Miguel.