Automatic Cell name change - Tab name

amir9s

New Member
Joined
Jun 10, 2016
Messages
9
Hi guys,

I've seen people post how to change a Tab name based on a cell's value/name using a macro, but what I'm looking for is the exact opposite.

I need to have a cell's name/value change based on a tab's name.

Would appreciate the help. Thank you
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,691
Hi guys,

I've seen people post how to change a Tab name based on a cell's value/name using a macro, but what I'm looking for is the exact opposite.

I need to have a cell's name/value change based on a tab's name.

Would appreciate the help. Thank you
You don't need a macro. Here's a formula you can put in that cell:

Code:
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-SEARCH("]",CELL("filename",A1)))
 

amir9s

New Member
Joined
Jun 10, 2016
Messages
9
You don't need a macro. Here's a formula you can put in that cell:

Code:
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-SEARCH("]",CELL("filename",A1)))

Thank you, that worked just fine :)
 

Forum statistics

Threads
1,085,693
Messages
5,385,214
Members
401,936
Latest member
stephenpoff

Some videos you may like

This Week's Hot Topics

Top