Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name a worksheet tab from cell in worksheet
I see it is possilbe to reference a worksheet tab name in a cell. Is it
possible to name a worksheet tab from a cell in that worksheet? So if you change the cell name it will also change the worksheet tab name. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name a worksheet tab from cell in worksheet
Hi Ken,
See http://www.mvps.org/dmcritchie/excel/pathname.htm Part 1: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) Part 2: I presume you meant "if I change the content of a cell like cell A!" It is not very practical going the other way as you could end up with an attempt to name two sheets with the same name. You would have to use macro code might be the line of code within a macro. activesheet.name = activesheet.range("A1") --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Ken King" wrote in message ... I see it is possilbe to reference a worksheet tab name in a cell. Is it possible to name a worksheet tab from a cell in that worksheet? So if you change the cell name it will also change the worksheet tab name. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
macro help | Excel Discussion (Misc queries) | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions |