code to name another sheet tab

[Cossie]

Hello everyone

I currently use this code to name the active sheet tab based on the value of cell b8.

Is it possible to name another sheet tab (say sheet 49) based on the same calculation


Sub Worksheet_Name()
With ActiveSheet
.Name = .[b8].Value & " Business Drivers"
.[C5].Select
End With
End Sub

 

[agihcam]

Sheets(49).Name = Sheets(49).Range("b8").value & "Business Drivers"

 

[Richard Schollar]

Maybe:

Sub Worksheet_Name() 
With ActiveSheet 
.Name = .[b8].Value & " Business Drivers" 
If ActiveSheet.Index<>49 Then Sheets(49).Name = .[B8].Value & "Business Drivers"
.[C5].Select 
End With 
End Sub

Best regards

Richard