How to change XL sheet names from cell range
OK, we are getting somewhere - thankyou to both who have replied!
By somewhere, I mean that I have got the second lot of code (By Bob
Phillips) to work, BUT I am usually only changing one of the 10 names so of
course it is erroring when it tries to change the sheet to an existing
name... SO, I then attempted to intergrate both Jim & Bob's code, using the
error handling from Jims with the code I have working from Bob's - guess
what... I am STILL not that clever!
Could one of you please direct me in how to trap the error so the routine
will work its way through the rest of the names, changing the worksheet name
to any that I have altered?
Thanks, Jim Cove (Bila)
"Bob Phillips" wrote:
Sub ChangeNames()
Dim j As Long
Dim i As Long
For j = 1 To Cells(Rows.Count, "A").End(xlUp).Row
i = i + 1
If Worksheets(i).Name < ActiveSheet.Name Then
Worksheets(i).Name = Cells(j, "A").Value
Else
j = j - 1
End If
Next j
End Sub
put the code in a standard code module
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Bila" wrote in message
...
I have been trying unsuccessfully to find a macro that will get data from
a
cell range on one sheet and change the worksheet names on another 10
sheets
to each of the names in that cell range. Can anyone offer a solution
please?
|