Create an Hyperlink using VBA
up vote
0
down vote
favorite
I need to create a link in cell E1, based on the information that are retrieve from a macro, the results from that macro are show in cells, example:
A1 : path (C:UsersmmDocuments)
B2: workbook(Tool.xlsx)
C1: worksheet (Atlas)
D1: cells ($B$160)
please could you help me, I try with:
Cells(R, C).Formula = "=HYPERLINK(""" & Path & "" & workbook & """,""" & "Link" & """)"
but only create a link to the folder, I would like to create a link to the cell reported in D1 ($B$160)
Thanks in advance
hyperlink
edited Nov 21 at 3:53
dustinos3
335216
asked Nov 20 at 22:04
M M
1
New contributor
M M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
0
down vote
favorite
I need to create a link in cell E1, based on the information that are retrieve from a macro, the results from that macro are show in cells, example:
A1 : path (C:UsersmmDocuments)
B2: workbook(Tool.xlsx)
C1: worksheet (Atlas)
D1: cells ($B$160)
please could you help me, I try with:
Cells(R, C).Formula = "=HYPERLINK(""" & Path & "" & workbook & """,""" & "Link" & """)"
but only create a link to the folder, I would like to create a link to the cell reported in D1 ($B$160)
Thanks in advance
hyperlink
edited Nov 21 at 3:53
dustinos3
335216
asked Nov 20 at 22:04
M M
1
New contributor
M M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I need to create a link in cell E1, based on the information that are retrieve from a macro, the results from that macro are show in cells, example:
A1 : path (C:UsersmmDocuments)
B2: workbook(Tool.xlsx)
C1: worksheet (Atlas)
D1: cells ($B$160)
please could you help me, I try with:
Cells(R, C).Formula = "=HYPERLINK(""" & Path & "" & workbook & """,""" & "Link" & """)"
but only create a link to the folder, I would like to create a link to the cell reported in D1 ($B$160)
Thanks in advance
hyperlink
edited Nov 21 at 3:53
dustinos3
335216
asked Nov 20 at 22:04
M M
1
New contributor
M M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I need to create a link in cell E1, based on the information that are retrieve from a macro, the results from that macro are show in cells, example:
A1 : path (C:UsersmmDocuments)
B2: workbook(Tool.xlsx)
C1: worksheet (Atlas)
D1: cells ($B$160)
please could you help me, I try with:
Cells(R, C).Formula = "=HYPERLINK(""" & Path & "" & workbook & """,""" & "Link" & """)"
but only create a link to the folder, I would like to create a link to the cell reported in D1 ($B$160)
Thanks in advance
hyperlink
hyperlink
edited Nov 21 at 3:53
dustinos3
335216
asked Nov 20 at 22:04
M M
1
New contributor
M M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 21 at 3:53
dustinos3
335216
asked Nov 20 at 22:04
M M
1
New contributor
M M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 21 at 3:53
dustinos3
335216
edited Nov 21 at 3:53
dustinos3
335216
edited Nov 21 at 3:53
dustinos3
335216
335216
asked Nov 20 at 22:04
M M
1
New contributor
M M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 20 at 22:04
M M
1
asked Nov 20 at 22:04
M M
1
1
New contributor
M M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
M M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
M M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
M M is a new contributor. Be nice, and check out our Code of Conduct.
M M is a new contributor. Be nice, and check out our Code of Conduct.
M M is a new contributor. Be nice, and check out our Code of Conduct.
M M is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53402276%2fcreate-an-hyperlink-using-vba%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
