need help with hyperlinks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Newman - 23 Jan 2006 15:47 GMT

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

Signature

Chris Newman

Reply to this Message

Tom Ogilvy - 23 Jan 2006 16:15 GMT

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"

Signature

Regards,
Tom Ogilvy

> 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
[quoted text clipped - 14 lines]
>
> cn

Reply to this Message