|
|
|
Author |
Message |
RandyJinPoway
|
Posted: Sat Nov 19 12:51:20 CST 2005 |
Top |
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?
Excel285
|
|
|
|
|
Crowbar
|
Posted: Sat Nov 19 12:51:20 CST 2005 |
Top |
|
|
|
british
|
Posted: Sat Nov 19 13:14:26 CST 2005 |
Top |
|
|
|
Darren
|
Posted: Sat Nov 19 13:26:02 CST 2005 |
Top |
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?
> Don't understand what you mean
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.aspx/excel-programming/200511/1
>
|
|
|
|
|
Gord
|
Posted: Sat Nov 19 14:46:28 CST 2005 |
Top |
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
>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?
>
>
>> Don't understand what you mean
>>
>> --
>> Message posted via OfficeKB.com
>> http://www.officekb.com/Uwe/Forums.aspx/excel-programming/200511/1
>>
|
|
|
|
|
chijanzen
|
Posted: Sun Nov 20 02:33:02 CST 2005 |
Top |
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/
> 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?
>
>
> > Don't understand what you mean
> >
> > --
> > Message posted via OfficeKB.com
> > http://www.officekb.com/Uwe/Forums.aspx/excel-programming/200511/1
> >
|
|
|
|
|
|
|