View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Die_Another_Day
 
Posts: n/a
Default Help with a Macro - Excel 2003

As far as having a global address you can use the "Hyperlink" function
in Excel to reference the main page which allows for future changes. it
does not however help you know.

For example:
A1 =
http://groups.google.com/group/micro...c0d5c030d9755/

B1 = d1b59fe11c0f62d1#d1b59fe11c0f62d1

C1 = =HYPERLINK(A1&B1,"Link to here")

HTH

Die_Another_Day