Help with Renaming Tab

[KiloHotel]

Hey Guys,

I want to rename tabs based on 2 seperate cell values,

I have the macro for renaming based on the one cell value but i can't figure out how to add another cell value on top so that both values are used in the renaming of the tab. I need to use the cell C2 value and A3 value.

Sub RenameSheet()<code style="box-sizing: inherit; font-size: 1em; font-family: Consolas, "Courier New", Courier, monospace;">
Dim rs As Worksheet

For Each rs In Sheets
rs.Name = rs.Range("C2")
Next rs

</code>End Sub

Thanks in advance!

 

[MARK858]

Just concatenate them...

Sub RenameSheet()
    Dim rs As Worksheet

    For Each rs In Sheets
        rs.Name = rs.Range("C2") & " " & rs.Range("A3")
    Next rs

End Sub

 

[KiloHotel]

Just concatenate them...

Sub RenameSheet()
    Dim rs As Worksheet

    For Each rs In Sheets
        rs.Name = rs.Range("C2") & " " & rs.Range("A3")
    Next rs

End Sub

Perfect! Thats what i was trying to do! just had a blank moment on how to concatenate them.

Thanks again.