Addcomment method errors
up vote
0
down vote
favorite
I'm facing a problem with the .AddComment function
Worksheets("Config").Range("I2:ZZ2").offset(index, 0).AddComment Worksheets("Library").Range("B2:ZZ2").offset(offset, 0).Value
What am I doing wrong? Im looping so a "With" statement is not possible here.
excel vba
asked Nov 12 at 9:03
Mattijn Stegeman
134
add a comment |
up vote
0
down vote
favorite
I'm facing a problem with the .AddComment function
Worksheets("Config").Range("I2:ZZ2").offset(index, 0).AddComment Worksheets("Library").Range("B2:ZZ2").offset(offset, 0).Value
What am I doing wrong? Im looping so a "With" statement is not possible here.
excel vba
asked Nov 12 at 9:03
Mattijn Stegeman
134
You have to apply it to each cell in turn, not the entire range in one go.
– Rory
Nov 12 at 9:07
You also have to make sure the cell you're trying to add a comment to doesn't already contain a comment.
– Darren Bartrup-Cook
Nov 12 at 9:10
@DarrenBartrup-Cook I do clear every cell before add comments to it.
– Mattijn Stegeman
Nov 12 at 9:11
@Rory I don't understand this. How should I write this?
– Mattijn Stegeman
Nov 12 at 9:13
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I'm facing a problem with the .AddComment function
Worksheets("Config").Range("I2:ZZ2").offset(index, 0).AddComment Worksheets("Library").Range("B2:ZZ2").offset(offset, 0).Value
What am I doing wrong? Im looping so a "With" statement is not possible here.
excel vba
asked Nov 12 at 9:03
Mattijn Stegeman
134
I'm facing a problem with the .AddComment function
Worksheets("Config").Range("I2:ZZ2").offset(index, 0).AddComment Worksheets("Library").Range("B2:ZZ2").offset(offset, 0).Value
What am I doing wrong? Im looping so a "With" statement is not possible here.
excel vba
excel vba
asked Nov 12 at 9:03
Mattijn Stegeman
134
asked Nov 12 at 9:03
Mattijn Stegeman
134
asked Nov 12 at 9:03
Mattijn Stegeman
134
asked Nov 12 at 9:03
Mattijn Stegeman
134
asked Nov 12 at 9:03
Mattijn Stegeman
134
134
You have to apply it to each cell in turn, not the entire range in one go.
– Rory
Nov 12 at 9:07
You also have to make sure the cell you're trying to add a comment to doesn't already contain a comment.
– Darren Bartrup-Cook
Nov 12 at 9:10
@DarrenBartrup-Cook I do clear every cell before add comments to it.
– Mattijn Stegeman
Nov 12 at 9:11
@Rory I don't understand this. How should I write this?
– Mattijn Stegeman
Nov 12 at 9:13
add a comment |
You have to apply it to each cell in turn, not the entire range in one go.
– Rory
Nov 12 at 9:07
You also have to make sure the cell you're trying to add a comment to doesn't already contain a comment.
– Darren Bartrup-Cook
Nov 12 at 9:10
@DarrenBartrup-Cook I do clear every cell before add comments to it.
– Mattijn Stegeman
Nov 12 at 9:11
@Rory I don't understand this. How should I write this?
– Mattijn Stegeman
Nov 12 at 9:13
You have to apply it to each cell in turn, not the entire range in one go.
– Rory
Nov 12 at 9:07
You have to apply it to each cell in turn, not the entire range in one go.
– Rory
Nov 12 at 9:07
You also have to make sure the cell you're trying to add a comment to doesn't already contain a comment.
– Darren Bartrup-Cook
Nov 12 at 9:10
You also have to make sure the cell you're trying to add a comment to doesn't already contain a comment.
– Darren Bartrup-Cook
Nov 12 at 9:10
@DarrenBartrup-Cook I do clear every cell before add comments to it.
– Mattijn Stegeman
Nov 12 at 9:11
@DarrenBartrup-Cook I do clear every cell before add comments to it.
– Mattijn Stegeman
Nov 12 at 9:11
@Rory I don't understand this. How should I write this?
– Mattijn Stegeman
Nov 12 at 9:13
@Rory I don't understand this. How should I write this?
– Mattijn Stegeman
Nov 12 at 9:13
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
accepted
You need to loop through each column as well:
for i = 9 to 702
Worksheets("Config").Cells(2 + index, i).AddComment Worksheets("Library").Cells(2 + index, i).Value
next i
answered Nov 12 at 9:21
Rory
23.8k51722
Thank you! But now I get errors when no value available in the "Library" worksheet...
– Mattijn Stegeman
Nov 12 at 11:02
@MattijnStegeman you won't get an error just because the cell in the Library sheet is empty.
– Rory
Nov 12 at 11:32
All is working now. Thank you so much for this answer!
– Mattijn Stegeman
Nov 13 at 17:55
add a comment |
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',
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%2f53258817%2faddcomment-method-errors%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
accepted
You need to loop through each column as well:
for i = 9 to 702
Worksheets("Config").Cells(2 + index, i).AddComment Worksheets("Library").Cells(2 + index, i).Value
next i
answered Nov 12 at 9:21
Rory
23.8k51722
Thank you! But now I get errors when no value available in the "Library" worksheet...
– Mattijn Stegeman
Nov 12 at 11:02
@MattijnStegeman you won't get an error just because the cell in the Library sheet is empty.
– Rory
Nov 12 at 11:32
All is working now. Thank you so much for this answer!
– Mattijn Stegeman
Nov 13 at 17:55
add a comment |
up vote
0
down vote
accepted
You need to loop through each column as well:
for i = 9 to 702
Worksheets("Config").Cells(2 + index, i).AddComment Worksheets("Library").Cells(2 + index, i).Value
next i
answered Nov 12 at 9:21
Rory
23.8k51722
Thank you! But now I get errors when no value available in the "Library" worksheet...
– Mattijn Stegeman
Nov 12 at 11:02
@MattijnStegeman you won't get an error just because the cell in the Library sheet is empty.
– Rory
Nov 12 at 11:32
All is working now. Thank you so much for this answer!
– Mattijn Stegeman
Nov 13 at 17:55
add a comment |
up vote
0
down vote
accepted
up vote
0
down vote
accepted
You need to loop through each column as well:
for i = 9 to 702
Worksheets("Config").Cells(2 + index, i).AddComment Worksheets("Library").Cells(2 + index, i).Value
next i
answered Nov 12 at 9:21
Rory
23.8k51722
You need to loop through each column as well:
for i = 9 to 702
Worksheets("Config").Cells(2 + index, i).AddComment Worksheets("Library").Cells(2 + index, i).Value
next i
answered Nov 12 at 9:21
Rory
23.8k51722
answered Nov 12 at 9:21
Rory
23.8k51722
answered Nov 12 at 9:21
Rory
23.8k51722
answered Nov 12 at 9:21
Rory
23.8k51722
23.8k51722
Thank you! But now I get errors when no value available in the "Library" worksheet...
– Mattijn Stegeman
Nov 12 at 11:02
@MattijnStegeman you won't get an error just because the cell in the Library sheet is empty.
– Rory
Nov 12 at 11:32
All is working now. Thank you so much for this answer!
– Mattijn Stegeman
Nov 13 at 17:55
add a comment |
Thank you! But now I get errors when no value available in the "Library" worksheet...
– Mattijn Stegeman
Nov 12 at 11:02
@MattijnStegeman you won't get an error just because the cell in the Library sheet is empty.
– Rory
Nov 12 at 11:32
All is working now. Thank you so much for this answer!
– Mattijn Stegeman
Nov 13 at 17:55
Thank you! But now I get errors when no value available in the "Library" worksheet...
– Mattijn Stegeman
Nov 12 at 11:02
Thank you! But now I get errors when no value available in the "Library" worksheet...
– Mattijn Stegeman
Nov 12 at 11:02
@MattijnStegeman you won't get an error just because the cell in the Library sheet is empty.
– Rory
Nov 12 at 11:32
@MattijnStegeman you won't get an error just because the cell in the Library sheet is empty.
– Rory
Nov 12 at 11:32
All is working now. Thank you so much for this answer!
– Mattijn Stegeman
Nov 13 at 17:55
All is working now. Thank you so much for this answer!
– Mattijn Stegeman
Nov 13 at 17:55
add a comment |
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53258817%2faddcomment-method-errors%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
You have to apply it to each cell in turn, not the entire range in one go.
– Rory
Nov 12 at 9:07
You also have to make sure the cell you're trying to add a comment to doesn't already contain a comment.
– Darren Bartrup-Cook
Nov 12 at 9:10
@DarrenBartrup-Cook I do clear every cell before add comments to it.
– Mattijn Stegeman
Nov 12 at 9:11
@Rory I don't understand this. How should I write this?
– Mattijn Stegeman
Nov 12 at 9:13