Macro to rename sheets based on cell value in another sheet [Solved/Closed]

Ask a question jlcorte14 2Posts Wednesday January 20, 2016Registration date January 20, 2016 Last seen - Latest answer on Jan 20, 2016 04:23PM
I am attempting to rename 5 sheets in a workbook based on values from a sheet titled Raw Data Information. The first sheet should be named based on 'Raw Data Information'!C2 then the next based on 'Raw Data Information'!C3 and so on. I can't seem to make this work. I can only find code that will work for me if it referneces a cell on the same active page. Can anyone help?
See more 
moins plus

Please, bare in mind that CCM is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Therefore, it is specifically requested from CCM forum users to correspond showing mutual respect. Therefore, when requesting assistance, it is suggested to be courteous, as for elsewhere in similar circumstances. (i.e. please, thank you, appreciate, grateful, etc.)

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.


Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!