To make it easier for someone to help you a few examples of what
you want to link to would be helpful, fortunately you can probably
find your an answer on one of my pages.
http://www.mvps.org/dmcritchie/excel....htm#hyperlink
and perhaps a solution something like:
=HYPERLINK("file://x:/mywebsite/dmcritchie/excel/" & A6 & ".htm",A6)
or something like
http://www.mvps.org/dmcritchie/excel...htm#hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#hyp2
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mustard" wrote in message ...
I have multiple files that i want to put a hyperlink to. Rather than doing it
one by one, is there a quick way to just automatically add a hyperlink to all
files?