I am trying to programmaticaly create a list of hyperlinks on a single
page to particular cells on another sheet in a different workbook. So
far I have been blocked at every turn. I keep getting "Reference is not
valid" errors.

I've been trying to find the "complete" syntax for creating hyperlinks.
I've googled for anwsers, checked the msdn site, and so far have come up
with nothing other than incomplete examples.

At this point I don't care whether I implement this as a formula using
"=hyperlink()" or as an object ".hyperlinks.add()".

Can anyone provide a link to complete docs or an example of how to link
to workbook::worksheet::cell?

Thanks in advance.

cn


--
Chris Newman
------------------------------------------------------------------------
Chris Newman's Profile: http://www.excelforum.com/member.php...o&userid=30739
View this thread: http://www.excelforum.com/showthread...hreadid=504049