Try this:
http://www.officearticles.com/excel/...ft_e xcel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"ceemo" wrote in
message ...

mm i name my sheets tabs according to date example

31-1
1-2
2-2
etc

can i extract this info using a formula to create a titla for my repot


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=507757