First code is helpful..only scenario it doesn't work is
1) if there is no existing cell comment then it doesn't add cell value in the comment. example if cell A1 has calculated value as 45 but currently no comment, macro doesnt do anything. I need this macro also to add 45 as cell comment.
2) if cell comment can be added on top of existing comment. currently it adds below existing comment.
thanks so much for help.