Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
up to 7 functions? | Excel Worksheet Functions |