Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab naming from a Reference cell
Hi All,
Using Excel 2007 Can I name a worksheet tab from a cell contained within the worksheet. I want to name a worksheet from the date contained in say A1 = 30/06/2009 (dd/mm/yyyy) so the tab would be called 'June' from the month number in A1. If so could someone give me either the function or the code to do this. If it is code could also detail how to apply it, as I am not that familiar with code. Many thanks for taking the time out to respond. FinanceGuru -- Wales - the land of fire breathing dragons and rugby playing wizards. -- Wales - the land of fire breathing dragons and rugby playing wizards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming worksheets tabs from another cell reference | Excel Worksheet Functions | |||
Naming a worksheet tab from a reference cell | Excel Worksheet Functions | |||
Naming a reference table for use in a VBA Code | Excel Discussion (Misc queries) | |||
reference cell from previous worksheet without "naming" worksheet | Excel Worksheet Functions | |||
Naming word tables or coding reference library with vba | Charts and Charting in Excel |