Replace your + with a & sign

"Mr. Matt" wrote:

I have the code below to rename Worksheet 2. When the value in 4, 6 is a
number, e.g. 5, I get an error. Text works fine. Any suggestions?

Thanks

Private Sub CommandButton1_Click()
Sheets(2).Name = Sheets(1).Cells(4, 6).Value + " Equip Info"
End Sub