need help with hyperlinks

[Chris Newman]

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

 

[Tom Ogilvy]

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" <[email protected]>
wrote in message
news:[email protected]...