Hi all,
I have found a "solution" to list all sheets name of a worksheet (http://www.excelfox.com/forum/f13/li...formula-119/):
Here is a method to list all sheet names in cells using formula.
Hit Ctrl + F3, New | Name : SheetNames
Refers to: =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")
In A2 and copied down (Prior to XL 2007),
=IF(ROWS($A$2:A2)<=COUNTA(SheetNames),INDEX(SheetNames,ROWS($A$2:A2) ),"")
XL 2007 and later:
=IFERROR(INDEX(SheetNames,ROWS($A$2:A2)),"")
Is there a way to get the cell containing the worksheet name to be colored of the same color of the worksheet tab?
Thanks in advance!
Gilberto
Bookmarks