Tab name into cell
 

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!

Tab name into cell
 

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


"texansgal" wrote in message
...
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!

Tab name into cell
 

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.

"texansgal" wrote:

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!