address function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top