to add a hyperlink formula in excel:
=HYPERLINK("#sheetname!"&CELL("address",A999))
where 'sheetname' is the name of the worksheet and
'A999' is the the cell to link to
the pound sign, # is _Necessary_
7.20.2010
Subscribe to:
Posts (Atom)
My random tech problems and chicken scratching for notes on what I did to solve them.