Renaming multiple sheets by cell reference

[Vivek2705]

I have total 11 sheets. I want to rename sheets from 2 to 11 by names mentioned in sheet1 cell range O1 to O10. Values in range O1 to O10 are result of concatenate formula. The sheets may also be hidden. Kindly give me the suitable vba code for above problem.

[JohnTopley]

Please Login or Register  to view this content.

Change "Sheet1" to sheet containing list of names

Assumes there are 11 sheets ("Sheets.count")

[Vivek2705]

Thanks John for the code. It worked...

[JohnTopley]

You're welcome. I appreciate the feedback.

If your question has been solved please mark the thread as being solved. ("Thread Tools" at top of first post).