Link_location is the path and file name to the document to be opened as
text. Link_location can refer to a place in a document €” such as a specific
cell or named range in an Excel worksheet or workbook, or to a bookmark in a
Microsoft Word document. The path can be to a file stored on a hard disk
drive, or the path can be a universal naming convention (UNC) path on a
server (in Microsoft Excel for Windows) or a Uniform Resource Locator (URL
(Uniform Resource Locator (URL): An address that specifies a protocol (such
as HTTP or FTP) and a location of an object, document, World Wide Web page,
or other destination on the Internet or an intranet, for example:
http://www.microsoft.com/.)) path on the Internet or an intranet.
I hope this helps


--
William<"M" 2007



"birdster" wrote:

I'm entering a hyperlink via the function tool.
Once I've completed the function and click on the text to take me to the
remote cell, I get the message "The address of this site is not valid. Check
the address and try again"
DOes anyone have any solution to this?

Thanks
CB