Need syntax for adding a hyperlink thru VBA

[Drdave1958]

Here's what I got...

code:
Sub TestHyper()
myfile = "Daves.jpg"
mylink = "DavesLink"
Path = "(\\Servername\Foldername\"
ActiveCell.Hyperlink.Add Path & myfile & mylink
End Sub

I've searched the site and the help file but I'm still going in circles. Will someone steer me in the right direction?

Thanks, Dave

 

[cboshdave]

I need to set internal links between cells. Is there a "HYPERLINK" type formula that does this?

I am actually looking for the same thing.
ActiveCell.Hyperlinks.Add Range("RangeName1"), Range("RangeName2")

I get a type mismatch on the second RangeName. RangeName2 is simply a rangename in the current worksheet that I want to jump to. I am sure it is simple. I just can't find the syntax.

Thanks,
Dave

 

[Pitcher8811]

I am actually looking for the same thing.
ActiveCell.Hyperlinks.Add Range("RangeName1"), Range("RangeName2")

I get a type mismatch on the second RangeName. RangeName2 is simply a rangename in the current worksheet that I want to jump to. I am sure it is simple. I just can't find the syntax.

Thanks,
Dave

Try this:
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= "'YourSheetName'!YourCellAddres" , TextToDisplay:="YourTextHere"

You can also pass the SubAddress as a string variable:

Dim SubAdd as String

SubAdd = "'" & Sheets(1).Name & "'" & EnterYourCellAddressHere


If you were going to add these hyperlinks to worksheets a lot, I would suggest creating a form to input the information and pass it into the macro.

 

[excel_solutions]

hi,

I want a formula which would do the following:
Matching the date (column B) with that in row H2 onwards, and then it will match the names written in column C with names in column H
and after matching these conditions, the hyperlink will connect to name in column H

please help!!!!

 

[cboshdave]

Can you provide some sample data that would clarify the issue?