G
Guest
I am doing some checks for specific text within the existing sheet name and
if the sheet name contains that value, I want to rename it to include
information from named range abc.
I'm using this to rename the sheet
Worksheets(i).Name = "TRY IT " & Range("abc") & " - Cover
Page"
I know I've got the right worksheet, but it's not being renamed. Does the
formula need to be changed?
Thanks,
Barb Reinhardt
if the sheet name contains that value, I want to rename it to include
information from named range abc.
I'm using this to rename the sheet
Worksheets(i).Name = "TRY IT " & Range("abc") & " - Cover
Page"
I know I've got the right worksheet, but it's not being renamed. Does the
formula need to be changed?
Thanks,
Barb Reinhardt