Formula that links to tab name

[Guest]

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

 

[Carim]

Hi,

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

does the job ...

HTH
Cheers
Carim

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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