Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot nest address function into another function | Excel Discussion (Misc queries) | |||
address function | Excel Discussion (Misc queries) | |||
Help With Address Function | Excel Worksheet Functions | |||
address() function | Excel Worksheet Functions | |||
ADDRESS function | Excel Discussion (Misc queries) |