How can i edit a cell comment..?

Hello,

to add some text and the the current date to any existing comment in the sheet, for example, use code along the lines of

Please Login or Register  to view this content.

Please Login or Register  to view this content.

for each j value i need to append the respective fault value in the comment box...i need help regarding this..so any one who knows pls let me know its urgent..thanks to all for their support

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

try this:

Please Login or Register  to view this content.

If a cell has a comment, the new text will be appended in a new line. If a cell does not have a comment, it will be skipped, i.e. no comment will be added.

cheers