Rename tab to cell contents

[Pierre]

Would like to have the tab name reflect the contents that appear in a
cell.
It may contain numbers such as "40 2010" which is the result of a
concatenated formula. . .(40 shipped in 2010, for example).
Or, a cell contents which mayalso include text such as "100 2015
RED" (also the result of concatenating cells).

Thanks for any code that could do this that may come your way.
Pierre

 

[JE McGimpsey]

See

http://mcgimpsey.com/excel/events/sheetnamefromcell.html

 

[Gary''s Student]

Hi Pierre:

Say we use cell B9. Will you fill the cell manually or by formula??

 

[Pierre]

See

   http://mcgimpsey.com/excel/events/sheetnamefromcell.html







- Show quoted text -

This works great!

Will fill by either text or formula, they both do the trick.

Thanks you Gary's Student and JE McGimpsey.

Pierre