Hi

I have about 1000 excel files and i need to put a hyper link in each of them
to a differnt file on a network drive, the file name is the same as one of
the cells on worksheet.

Is there a way to include the text in the cell as part of the hyperlink text?

Andy