View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FiluDlidu FiluDlidu is offline
external usenet poster
 
Posts: 66
Default 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