Use Find Method to look for the of a Range from another worksheet
0
I am currently stuck in the Find method not properly working in my current project. The idea is there are 2 sheets. VBA should copy the range value from worksheet "Seed" and then go to another sheet ("Source") and find the same value in "Source" sheet.
Cells.Find(Worksheets("SEED").application.ActiveCell.Value, xlValues, xlByColumns).Activate
excel
asked Nov 22 '18 at 7:05
Mark Mark
1
add a comment |
0
I am currently stuck in the Find method not properly working in my current project. The idea is there are 2 sheets. VBA should copy the range value from worksheet "Seed" and then go to another sheet ("Source") and find the same value in "Source" sheet.
Cells.Find(Worksheets("SEED").application.ActiveCell.Value, xlValues, xlByColumns).Activate
excel
asked Nov 22 '18 at 7:05
Mark Mark
1
"to look for the <what>? of a Range"??? Have you considered splitting up the different activities into different steps of code? i.e. copy a range, then perform a find, instead of doing it all in one line of code? And why "Activate"? That is one of the most useless statements ever
– teylyn
Nov 22 '18 at 7:17
Teylyn, it's like the statement gets the value of a range in worksheet seed say the value of the range is "apple", the code then transfers from sheet "seed" to sheet "source" and looks for apple in that sheet performs certain action then goes back to sheet seed and gets another range value to find in sheet source... this will continue to loop. do you have any suggestion? appreciate all the help. thanks
– Mark
Nov 22 '18 at 8:36
No, "it's like" I read your subject line and there are words missing and "it's like" it does not make sense. Please get your act together before your question gets closed and use proper language to help people understand what you "like" want to say.
– teylyn
Nov 24 '18 at 5:23
add a comment |
0
0
0
I am currently stuck in the Find method not properly working in my current project. The idea is there are 2 sheets. VBA should copy the range value from worksheet "Seed" and then go to another sheet ("Source") and find the same value in "Source" sheet.
Cells.Find(Worksheets("SEED").application.ActiveCell.Value, xlValues, xlByColumns).Activate
excel
asked Nov 22 '18 at 7:05
Mark Mark
1
I am currently stuck in the Find method not properly working in my current project. The idea is there are 2 sheets. VBA should copy the range value from worksheet "Seed" and then go to another sheet ("Source") and find the same value in "Source" sheet.
Cells.Find(Worksheets("SEED").application.ActiveCell.Value, xlValues, xlByColumns).Activate
excel
excel
asked Nov 22 '18 at 7:05
Mark Mark
1
asked Nov 22 '18 at 7:05
Mark Mark
1
asked Nov 22 '18 at 7:05
Mark Mark
1
asked Nov 22 '18 at 7:05
Mark Mark
1
asked Nov 22 '18 at 7:05
Mark Mark
1
1
"to look for the <what>? of a Range"??? Have you considered splitting up the different activities into different steps of code? i.e. copy a range, then perform a find, instead of doing it all in one line of code? And why "Activate"? That is one of the most useless statements ever
– teylyn
Nov 22 '18 at 7:17
Teylyn, it's like the statement gets the value of a range in worksheet seed say the value of the range is "apple", the code then transfers from sheet "seed" to sheet "source" and looks for apple in that sheet performs certain action then goes back to sheet seed and gets another range value to find in sheet source... this will continue to loop. do you have any suggestion? appreciate all the help. thanks
– Mark
Nov 22 '18 at 8:36
No, "it's like" I read your subject line and there are words missing and "it's like" it does not make sense. Please get your act together before your question gets closed and use proper language to help people understand what you "like" want to say.
– teylyn
Nov 24 '18 at 5:23
add a comment |
"to look for the <what>? of a Range"??? Have you considered splitting up the different activities into different steps of code? i.e. copy a range, then perform a find, instead of doing it all in one line of code? And why "Activate"? That is one of the most useless statements ever
– teylyn
Nov 22 '18 at 7:17
Teylyn, it's like the statement gets the value of a range in worksheet seed say the value of the range is "apple", the code then transfers from sheet "seed" to sheet "source" and looks for apple in that sheet performs certain action then goes back to sheet seed and gets another range value to find in sheet source... this will continue to loop. do you have any suggestion? appreciate all the help. thanks
– Mark
Nov 22 '18 at 8:36
No, "it's like" I read your subject line and there are words missing and "it's like" it does not make sense. Please get your act together before your question gets closed and use proper language to help people understand what you "like" want to say.
– teylyn
Nov 24 '18 at 5:23
"to look for the <what>? of a Range"??? Have you considered splitting up the different activities into different steps of code? i.e. copy a range, then perform a find, instead of doing it all in one line of code? And why "Activate"? That is one of the most useless statements ever
– teylyn
Nov 22 '18 at 7:17
"to look for the <what>? of a Range"??? Have you considered splitting up the different activities into different steps of code? i.e. copy a range, then perform a find, instead of doing it all in one line of code? And why "Activate"? That is one of the most useless statements ever
– teylyn
Nov 22 '18 at 7:17
Teylyn, it's like the statement gets the value of a range in worksheet seed say the value of the range is "apple", the code then transfers from sheet "seed" to sheet "source" and looks for apple in that sheet performs certain action then goes back to sheet seed and gets another range value to find in sheet source... this will continue to loop. do you have any suggestion? appreciate all the help. thanks
– Mark
Nov 22 '18 at 8:36
Teylyn, it's like the statement gets the value of a range in worksheet seed say the value of the range is "apple", the code then transfers from sheet "seed" to sheet "source" and looks for apple in that sheet performs certain action then goes back to sheet seed and gets another range value to find in sheet source... this will continue to loop. do you have any suggestion? appreciate all the help. thanks
– Mark
Nov 22 '18 at 8:36
No, "it's like" I read your subject line and there are words missing and "it's like" it does not make sense. Please get your act together before your question gets closed and use proper language to help people understand what you "like" want to say.
– teylyn
Nov 24 '18 at 5:23
No, "it's like" I read your subject line and there are words missing and "it's like" it does not make sense. Please get your act together before your question gets closed and use proper language to help people understand what you "like" want to say.
– teylyn
Nov 24 '18 at 5:23
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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
});
}
});
draft saved
draft discarded
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%2f53425510%2fuse-find-method-to-look-for-the-of-a-range-from-another-worksheet%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
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- 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.
draft saved
draft discarded
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%2f53425510%2fuse-find-method-to-look-for-the-of-a-range-from-another-worksheet%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
"to look for the <what>? of a Range"??? Have you considered splitting up the different activities into different steps of code? i.e. copy a range, then perform a find, instead of doing it all in one line of code? And why "Activate"? That is one of the most useless statements ever
– teylyn
Nov 22 '18 at 7:17
Teylyn, it's like the statement gets the value of a range in worksheet seed say the value of the range is "apple", the code then transfers from sheet "seed" to sheet "source" and looks for apple in that sheet performs certain action then goes back to sheet seed and gets another range value to find in sheet source... this will continue to loop. do you have any suggestion? appreciate all the help. thanks
– Mark
Nov 22 '18 at 8:36
No, "it's like" I read your subject line and there are words missing and "it's like" it does not make sense. Please get your act together before your question gets closed and use proper language to help people understand what you "like" want to say.
– teylyn
Nov 24 '18 at 5:23