I have used the following previously:-
Sub Rename()
Sheets("old name").Select
Sheets("old name").Name = "new name"
End Sub

Hope this helps

"Waki" wrote:

I have a list of loan numbers that I want to use to rename worksheet tabs,
any way to do that?