need help with hyperlinks
 

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

need help with hyperlinks
 

for the hyperlink worksheet function, there are examples in the help.

for a hard coded hyperlink, turn on the macro recorder and then put in the
hyperlink manually. turn off the macro recorder and look at the recorded
code:

This is what i recorded:

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:=
_
"Sheet3!B9", TextToDisplay:="Jacks cell"

--
Regards,
Tom Ogilvy


"Chris Newman"
wrote in message
news:Chris.Newman.223h1b_1138031402.5104@excelforu m-nospam.com...

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