Addcomment method errors












0














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







share|improve this question






















  • You have to apply it to each cell in turn, not the entire range in one go.
    – Rory
    Nov 12 '18 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 '18 at 9:10










  • @DarrenBartrup-Cook I do clear every cell before add comments to it.
    – Mattijn Stegeman
    Nov 12 '18 at 9:11










  • @Rory I don't understand this. How should I write this?
    – Mattijn Stegeman
    Nov 12 '18 at 9:13
















0














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







share|improve this question






















  • You have to apply it to each cell in turn, not the entire range in one go.
    – Rory
    Nov 12 '18 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 '18 at 9:10










  • @DarrenBartrup-Cook I do clear every cell before add comments to it.
    – Mattijn Stegeman
    Nov 12 '18 at 9:11










  • @Rory I don't understand this. How should I write this?
    – Mattijn Stegeman
    Nov 12 '18 at 9:13














0












0








0







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







share|improve this question













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






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 12 '18 at 9:03









Mattijn StegemanMattijn Stegeman

134




134












  • You have to apply it to each cell in turn, not the entire range in one go.
    – Rory
    Nov 12 '18 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 '18 at 9:10










  • @DarrenBartrup-Cook I do clear every cell before add comments to it.
    – Mattijn Stegeman
    Nov 12 '18 at 9:11










  • @Rory I don't understand this. How should I write this?
    – Mattijn Stegeman
    Nov 12 '18 at 9:13


















  • You have to apply it to each cell in turn, not the entire range in one go.
    – Rory
    Nov 12 '18 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 '18 at 9:10










  • @DarrenBartrup-Cook I do clear every cell before add comments to it.
    – Mattijn Stegeman
    Nov 12 '18 at 9:11










  • @Rory I don't understand this. How should I write this?
    – Mattijn Stegeman
    Nov 12 '18 at 9:13
















You have to apply it to each cell in turn, not the entire range in one go.
– Rory
Nov 12 '18 at 9:07




You have to apply it to each cell in turn, not the entire range in one go.
– Rory
Nov 12 '18 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 '18 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 '18 at 9:10












@DarrenBartrup-Cook I do clear every cell before add comments to it.
– Mattijn Stegeman
Nov 12 '18 at 9:11




@DarrenBartrup-Cook I do clear every cell before add comments to it.
– Mattijn Stegeman
Nov 12 '18 at 9:11












@Rory I don't understand this. How should I write this?
– Mattijn Stegeman
Nov 12 '18 at 9:13




@Rory I don't understand this. How should I write this?
– Mattijn Stegeman
Nov 12 '18 at 9:13












1 Answer
1






active

oldest

votes


















0














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





share|improve this answer





















  • Thank you! But now I get errors when no value available in the "Library" worksheet...
    – Mattijn Stegeman
    Nov 12 '18 at 11:02










  • @MattijnStegeman you won't get an error just because the cell in the Library sheet is empty.
    – Rory
    Nov 12 '18 at 11:32










  • All is working now. Thank you so much for this answer!
    – Mattijn Stegeman
    Nov 13 '18 at 17:55











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


















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









0














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





share|improve this answer





















  • Thank you! But now I get errors when no value available in the "Library" worksheet...
    – Mattijn Stegeman
    Nov 12 '18 at 11:02










  • @MattijnStegeman you won't get an error just because the cell in the Library sheet is empty.
    – Rory
    Nov 12 '18 at 11:32










  • All is working now. Thank you so much for this answer!
    – Mattijn Stegeman
    Nov 13 '18 at 17:55
















0














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





share|improve this answer





















  • Thank you! But now I get errors when no value available in the "Library" worksheet...
    – Mattijn Stegeman
    Nov 12 '18 at 11:02










  • @MattijnStegeman you won't get an error just because the cell in the Library sheet is empty.
    – Rory
    Nov 12 '18 at 11:32










  • All is working now. Thank you so much for this answer!
    – Mattijn Stegeman
    Nov 13 '18 at 17:55














0












0








0






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





share|improve this answer












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






share|improve this answer












share|improve this answer



share|improve this answer










answered Nov 12 '18 at 9:21









RoryRory

24k51723




24k51723












  • Thank you! But now I get errors when no value available in the "Library" worksheet...
    – Mattijn Stegeman
    Nov 12 '18 at 11:02










  • @MattijnStegeman you won't get an error just because the cell in the Library sheet is empty.
    – Rory
    Nov 12 '18 at 11:32










  • All is working now. Thank you so much for this answer!
    – Mattijn Stegeman
    Nov 13 '18 at 17:55


















  • Thank you! But now I get errors when no value available in the "Library" worksheet...
    – Mattijn Stegeman
    Nov 12 '18 at 11:02










  • @MattijnStegeman you won't get an error just because the cell in the Library sheet is empty.
    – Rory
    Nov 12 '18 at 11:32










  • All is working now. Thank you so much for this answer!
    – Mattijn Stegeman
    Nov 13 '18 at 17:55
















Thank you! But now I get errors when no value available in the "Library" worksheet...
– Mattijn Stegeman
Nov 12 '18 at 11:02




Thank you! But now I get errors when no value available in the "Library" worksheet...
– Mattijn Stegeman
Nov 12 '18 at 11:02












@MattijnStegeman you won't get an error just because the cell in the Library sheet is empty.
– Rory
Nov 12 '18 at 11:32




@MattijnStegeman you won't get an error just because the cell in the Library sheet is empty.
– Rory
Nov 12 '18 at 11:32












All is working now. Thank you so much for this answer!
– Mattijn Stegeman
Nov 13 '18 at 17:55




All is working now. Thank you so much for this answer!
– Mattijn Stegeman
Nov 13 '18 at 17:55


















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














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





















































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







-

Popular posts from this blog

Coverage of Google Street View

Image
Coverage of Google Street View From Wikipedia, the free encyclopedia Jump to navigation Jump to search Countries and dependencies with:    mostly full coverage    partial coverage    full or partial coverage planned (official)    full or partial coverage planned (unofficial)    views of selected businesses and/or tourist attractions only    views of private businesses only    no current or planned coverage Google Street View was first introduced in the United States on May 25, 2007, and until November 26, 2008, featured camera icon markers, each representing at least one major city or area (such as a park), and usually the other nearby cities, towns, suburbs, and parks. Many areas that had coverage were represented by icons. Contents 1 Key additions 2 Timeline of introductions 2.1 2007 2.2 2008 2.3 2009 2.4 2010 2.5 2011 2.6 2012 2.7 2013 2.8 2014 2.9 20...
Read more

Full-time equivalent

Image
Full-time equivalent From Wikipedia, the free encyclopedia Jump to navigation Jump to search Full-time equivalent ( FTE ) or whole time equivalent ( WTE ) is a unit that indicates the workload of an employed person (or student) in a way that makes workloads or class loads comparable [1] across various contexts. FTE is often used to measure a worker's or student's involvement in a project, or to track cost reductions in an organization. An FTE of 1.0 is equivalent to a full-time worker or student, while an FTE of 0.5 signals half of a full work or school load. [2] Contents 1 U.S. Federal Government 2 In education 2.1 Example 3 Notes 4 References U.S. Federal Government [ edit ] In the U.S. Federal Government, FTE is defined by the Government Accountability Office (GAO) as the number of total hours worked divided by the maximum number of compensable hours in a full-time schedule as...
Read more

Surfing

Image
Surfing From Wikipedia, the free encyclopedia Jump to navigation Jump to search This article is about stand-up ocean surfing. For other uses, see Surfing (disambiguation). "Surfer" redirects here. For other uses, see Surfer (disambiguation). Surfing A surfer at the Cayucos Pier, Cayucos, California Highest governing body World Surf League (WSL) Characteristics Mixed gender Yes, separate competitions Presence Country or region Worldwide Olympic Will debut in 2020 Surfing on the Gold Coast, Queensland, Australia Surfing is a surface water sport in which the wave rider, referred to as a surfer, rides on the forward or deep face of a moving wave, which usually carries the surfer towards the shore. Waves suitable for surfing are primarily found in the ocean, but can also be found in lakes or rivers in the form of a standing wave or tidal bore. However, surfers can also utilize artifi...
Read more