Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet tab name
Excel 2003 on XP.
What is the syntax to return the worksheet tab name in a cell? What I am after is when I rename a worksheet at the tab, I wont this reflected in a cell on that worksheet. Or is it possible that when I copy a previous worksheet, a cell automatically creates a new sequential number, ie if the latest number is 15 (that is a tab is named 15 an a cell reflects this number) if I copy this worksheet (or any other in this file) the cell changes to 16, and I obviously would want the Tab to be renamed 16 as well. Make sense? Many thanks DeanH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions |