Assuming that the workbook has been saved

=ADDRESS(1,2,,,MID(CELL("Filename",Sheet2!A1),FIND ("]",CELL("Filename",Sheet2!A1))+1,99))

--
HTH

Bob

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

"FiluDlidu" wrote in message
...
Hi,

The ADDRESS function goes:
(row_num,column_num,[abs_num],[a1],[sheet_text])

My problem resides in the last argument... Which function should I use to
steal the name of the sheet I want, so that if this sheet was ever to be
renamed, the argument would also automatically update to the new name?

Hope my question is clear enough,
Félix