Previous Topic Next Topic

Macro to rename tabs based on cell reference on another sheet

Closed
jlcorte14 Posts 1 Registration date Wednesday January 20, 2016 Status Member Last seen January 20, 2016 - Jan 20, 2016 at 07:01 PM
 Blocked Profile - Jan 20, 2016 at 07:15 PM
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!
Related:

1 response

Answer 1 / 1
Blocked Profile
Jan 20, 2016 at 07:15 PM
Post your code, and let us help......
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses