what formula do you use to get the name of a tab?
 

what formula do you use to get the name of a tab?
 

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

The workbook has to have been saved before it will work

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"vc" wrote in message
...

what formula do you use to get the name of a tab?
 

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

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"vc" wrote in message
...