Updating Hyperlink with sheet name change?

[Guest]

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

 

[keepITcool]

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 >