Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab Names
Is there a way to change the tab names to reflect what the cells say, i.e. in
worksheet 2, cells B11 through U11? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab Names
Don't understand what you mean
-- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab Names
Have you tried right clicking the sheet tabs and clicking on rename? -- british.assassi ------------------------------------------------------------------------ british.assassi's Profile: http://www.excelforum.com/member.php...o&userid=28884 View this thread: http://www.excelforum.com/showthread...hreadid=486550 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab Names
I have a wookbook with 21 sheets. In sheet 2, cells B11 through U11 are the
cells that will change. I need to see if it is possible to change the proceeding sheets to reflect these cells I mentioned. For example, if I have PA1, PA2, PA3... in cells B11, B12, B13..., I need to change each tab name to reflect PA1, PA2, PA3... Make sense? "Crowbar via OfficeKB.com" wrote: Don't understand what you mean -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab Names
Darren
You have 21 sheets, but only 20 values in B11:U11. Which 20 sheets out of the 21 are to be re-named? All but Sheet2? Or..........?? Gord Dibben Excel MVP On Sat, 19 Nov 2005 11:26:02 -0800, Darren wrote: I have a wookbook with 21 sheets. In sheet 2, cells B11 through U11 are the cells that will change. I need to see if it is possible to change the proceeding sheets to reflect these cells I mentioned. For example, if I have PA1, PA2, PA3... in cells B11, B12, B13..., I need to change each tab name to reflect PA1, PA2, PA3... Make sense? "Crowbar via OfficeKB.com" wrote: Don't understand what you mean -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab Names
Darren:
try, Dim sht As Worksheet i = 2 For Each sht In Sheets With Sheet2 'codename If .Cells(11, i) < "" And .Cells(11, i) < sht.Name Then sht.Name = .Cells(11, i) End If i = i + 1 End With Next sht -- 天行健,君*以自強不息 地勢坤,君*以厚德載物 http://www.vba.com.tw/plog/ "Darren" wrote: I have a wookbook with 21 sheets. In sheet 2, cells B11 through U11 are the cells that will change. I need to see if it is possible to change the proceeding sheets to reflect these cells I mentioned. For example, if I have PA1, PA2, PA3... in cells B11, B12, B13..., I need to change each tab name to reflect PA1, PA2, PA3... Make sense? "Crowbar via OfficeKB.com" wrote: Don't understand what you mean -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
return all worksheet tab names and chart sheet tab names in report - an example | Excel Programming | |||
Change names of files in a folder to match names in Excel Column | Excel Programming |