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

[Sandy Mann]

=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

[email protected]
[email protected] with @tiscali.co.uk

 

[Bob Phillips]

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)