| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab Names to Match Cell Values when Changed
In cell A1 I have the year 2008.
In cells A2 through A4 I have a formula to add one year as I move down each cell so that in A2 would be 2009, A3-2010 and so on. I also four worksheets that are named for each of those years. I would like to have VBA code to rename the TAB Names when I change cell A1 which will in turn change each for the four TAB Names to match whats in cells A1 - A4 respectively. Hope my question is clear enough for someone to help me come up with a solution. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The column names (A,B,C, etc...) changed to numbers?????????? | Setting up and Configuration of Excel | |||
| Cell values have changed | Excel Discussion (Misc queries) | |||
| tab names from cell values | Excel Discussion (Misc queries) | |||
| Compare and match names and extract a cell content | Excel Worksheet Functions | |||
| The columns names on my sheet have changed!! | Excel Discussion (Misc queries) | |||
Threaded Mode
