Hi, I am using a worksheet with hyperlinks pointing to cells in the worksheet as a template. How do I get the hyperlinks to update so they refer to a new sheet name? Right now I am manually removing and recreating all the hyperlinks.

TIA


Todd

use the hyperlink worksheetfunction.

you'll have to be VERY carefull with it's arguments.

syntax which works for me:
=hyperlink("[c:\path\my work book.xls]#'sheet name'!a1")


the [] can go around the whole path
the # is used between address and subaddress
the '' should be used to pad the sheet name else names with spaces wont
work)

the only glitch:
a file path with a # cannot be opened... as the function parses it at the
wrong point...



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"?B?VG9kZA==?=" wrote:

Hi, I am using a worksheet with hyperlinks pointing to cells in the
worksheet as a template. How do I get the hyperlinks to update so
they refer to a new sheet name? Right now I am manually removing and
recreating all the hyperlinks.

TIA


Todd