Creating a hyperlink that references itself and continues to do so when filled down
I have code that copies the row of the active cell and replicates it in a new row under the selected cell and a hyperlink that calls the code.
In the example below, if I click on the top ‘clickMe’:
'clickMe', date1, formula1, formula2
'clickMe', date2, formula1, formula2
The row is replicated under the row where I clicked the hyperlink:
'clickMe', 'date1', formula1, formula2
'clickMe', 'date1', formula1, formula2
'clickMe', 'date2', formula1, formula2
The problem I have is that the only way I know how to configure the hyperlink to call the code is to reference itself, but I must type in the cell reference. I need to replicate this on many rows so I would like to fill the hyperlink down to the other cells. This does not work, because the original hyperlink's cell reference is persisted and so it is always the top row that is duplicated and not the row in which I clicked.
Does anyone know how to configure a hyperlink to reference itself, so that when filled down it continues to reference itself and not the original cell it was dragged from?
microsoft-excel worksheet-function vba hyperlink
asked Jan 20 at 21:23
miguel.orlansmiguel.orlans
11
add a comment |
I have code that copies the row of the active cell and replicates it in a new row under the selected cell and a hyperlink that calls the code.
In the example below, if I click on the top ‘clickMe’:
'clickMe', date1, formula1, formula2
'clickMe', date2, formula1, formula2
The row is replicated under the row where I clicked the hyperlink:
'clickMe', 'date1', formula1, formula2
'clickMe', 'date1', formula1, formula2
'clickMe', 'date2', formula1, formula2
The problem I have is that the only way I know how to configure the hyperlink to call the code is to reference itself, but I must type in the cell reference. I need to replicate this on many rows so I would like to fill the hyperlink down to the other cells. This does not work, because the original hyperlink's cell reference is persisted and so it is always the top row that is duplicated and not the row in which I clicked.
Does anyone know how to configure a hyperlink to reference itself, so that when filled down it continues to reference itself and not the original cell it was dragged from?
microsoft-excel worksheet-function vba hyperlink
asked Jan 20 at 21:23
miguel.orlansmiguel.orlans
11
1
... and what exactly is your question? If it is "please write this code for me for free", you won't get that here. Please take the tour and learn How to Ask.
– teylyn
Jan 20 at 21:58
Please edit your question and add the clarification there. Don't add details in comments. Post a comment when your question has been fixed.
– teylyn
Jan 22 at 19:48
add a comment |
I have code that copies the row of the active cell and replicates it in a new row under the selected cell and a hyperlink that calls the code.
In the example below, if I click on the top ‘clickMe’:
'clickMe', date1, formula1, formula2
'clickMe', date2, formula1, formula2
The row is replicated under the row where I clicked the hyperlink:
'clickMe', 'date1', formula1, formula2
'clickMe', 'date1', formula1, formula2
'clickMe', 'date2', formula1, formula2
The problem I have is that the only way I know how to configure the hyperlink to call the code is to reference itself, but I must type in the cell reference. I need to replicate this on many rows so I would like to fill the hyperlink down to the other cells. This does not work, because the original hyperlink's cell reference is persisted and so it is always the top row that is duplicated and not the row in which I clicked.
Does anyone know how to configure a hyperlink to reference itself, so that when filled down it continues to reference itself and not the original cell it was dragged from?
microsoft-excel worksheet-function vba hyperlink
asked Jan 20 at 21:23
miguel.orlansmiguel.orlans
11
I have code that copies the row of the active cell and replicates it in a new row under the selected cell and a hyperlink that calls the code.
In the example below, if I click on the top ‘clickMe’:
'clickMe', date1, formula1, formula2
'clickMe', date2, formula1, formula2
The row is replicated under the row where I clicked the hyperlink:
'clickMe', 'date1', formula1, formula2
'clickMe', 'date1', formula1, formula2
'clickMe', 'date2', formula1, formula2
The problem I have is that the only way I know how to configure the hyperlink to call the code is to reference itself, but I must type in the cell reference. I need to replicate this on many rows so I would like to fill the hyperlink down to the other cells. This does not work, because the original hyperlink's cell reference is persisted and so it is always the top row that is duplicated and not the row in which I clicked.
Does anyone know how to configure a hyperlink to reference itself, so that when filled down it continues to reference itself and not the original cell it was dragged from?
microsoft-excel worksheet-function vba hyperlink
microsoft-excel worksheet-function vba hyperlink
asked Jan 20 at 21:23
miguel.orlansmiguel.orlans
11
asked Jan 20 at 21:23
miguel.orlansmiguel.orlans
11
edited Jan 23 at 8:11
miguel.orlans
asked Jan 20 at 21:23
miguel.orlansmiguel.orlans
11
asked Jan 20 at 21:23
miguel.orlansmiguel.orlans
11
asked Jan 20 at 21:23
miguel.orlansmiguel.orlans
11
11
1
... and what exactly is your question? If it is "please write this code for me for free", you won't get that here. Please take the tour and learn How to Ask.
– teylyn
Jan 20 at 21:58
Please edit your question and add the clarification there. Don't add details in comments. Post a comment when your question has been fixed.
– teylyn
Jan 22 at 19:48
add a comment |
1
... and what exactly is your question? If it is "please write this code for me for free", you won't get that here. Please take the tour and learn How to Ask.
– teylyn
Jan 20 at 21:58
Please edit your question and add the clarification there. Don't add details in comments. Post a comment when your question has been fixed.
– teylyn
Jan 22 at 19:48
1
1
... and what exactly is your question? If it is "please write this code for me for free", you won't get that here. Please take the tour and learn How to Ask.
– teylyn
Jan 20 at 21:58
... and what exactly is your question? If it is "please write this code for me for free", you won't get that here. Please take the tour and learn How to Ask.
– teylyn
Jan 20 at 21:58
Please edit your question and add the clarification there. Don't add details in comments. Post a comment when your question has been fixed.
– teylyn
Jan 22 at 19:48
Please edit your question and add the clarification there. Don't add details in comments. Post a comment when your question has been fixed.
– teylyn
Jan 22 at 19:48
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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%2fsuperuser.com%2fquestions%2f1396396%2fcreating-a-hyperlink-that-references-itself-and-continues-to-do-so-when-filled-d%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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%2fsuperuser.com%2fquestions%2f1396396%2fcreating-a-hyperlink-that-references-itself-and-continues-to-do-so-when-filled-d%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
1
... and what exactly is your question? If it is "please write this code for me for free", you won't get that here. Please take the tour and learn How to Ask.
– teylyn
Jan 20 at 21:58
Please edit your question and add the clarification there. Don't add details in comments. Post a comment when your question has been fixed.
– teylyn
Jan 22 at 19:48