Formula that links to tab name
 

If I have "August" as the name of my sheet, is there a formula that can be
used in a cell that refers to this....and so on for other months? ie...

Tab Name "August"
Cell A1 =TabName

Formula that links to tab name
 

Hi,

=MID(CELL("filename",A1), FIND("]", CELL("filename",A1))+ 1, 255)

does the job ...

HTH
Cheers
Carim

Formula that links to tab name
 

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"luvthavodka" wrote in message
...
If I have "August" as the name of my sheet, is there a formula that can be
used in a cell that refers to this....and so on for other months? ie...

Tab Name "August"
Cell A1 =TabName