Status: Solved
Priority: Medium
Security: Public
Views: 837
Last Modified: 2012-05-10

excel hyperlink function within vba

I am using the following VBA expression but the interpreter complains that its invalid:
Worksheets("sheet1").Range("J13").Formula = "=HYPERLINK(""http://www.google.com"" | ""GOOGLE"")"

I am simply trying to create a hyperlink inside a cell. I know the excel function =HYPERLINK("http://www.google.ca"|"GOTO www.google.ca")
is correct, why does it not work in VBA?

I am using Excel 2010.

OTNAdmin

Asked: 2010-09-20

Advertise Here

1 Solution

LVL 33

jppintoCommented: 2010-09-20

Please trt like this:

Worksheets("sheet1").Range("J13").Formula = "HYPERLINK("http://www.google.com";"GOOGLE")"

jppinto

LVL 6

KnutsonBMCommented: 2010-09-20

Try This:

Worksheets("sheet1").Range("J13").Select
ActiveCell.FormulaR1C1 = _
"=HYPERLINK(""http://www.google.ca"",""GOTO www.google.ca"")"

-Brandon

LVL 33

Todd GerbertIT ConsultantCommented: 2010-09-20

Parameters to Excel functions should be seperated by commas...
Worksheets("sheet1").Range("J13").Formula = "=HYPERLINK(""http://www.google.com"", ""GOOGLE"")"

LVL 6

KnutsonBMCommented: 2010-09-20

This one has the wording you wanted:

Worksheets("sheet1").Range("J13").Select
ActiveCell.FormulaR1C1 = _
"=HYPERLINK(""http://www.google.com"",""Google"")"

-Brandon

LVL 33

jppintoCommented: 2010-09-20

The correct way to do it, instead of using the .Formula is to use .Hyperlinks, like this:

Worksheets("Sheet1").Range("B3").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= "http://www.google.com/", TextToDisplay:="GOOGLE"

jppinto

LVL 33

jppintoCommented: 2010-09-20

Or even better:

ActiveSheet.Hyperlinks.Add Anchor:=Range("B3"), Address:= "http://www.google.com/", TextToDisplay:="GOOGLE"

jppinto

LVL 6

KnutsonBMCommented: 2010-09-20

Many different options to choose from................

-brandon

OTNAdminAuthor Commented: 2010-09-20

thanks

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

excel hyperlink function within vba

Join & Write a Comment Already a member? Login.

Featured Post