address function
 

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

address function
 

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