Macro to rename tabs based on cell reference on another sheet [Closed]

Report
Posts
2
Registration date
Wednesday January 20, 2016
Status
Member
Last seen
January 20, 2016
-
 Blocked Profile -
Hello,
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 references a cell on the same active page. Can anyone please point me in the right direction?

Thanks so much in advance, I know your time is valuable!

1 reply


Post your code, and let us help......

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!