Hey N Pradhan,
please find the below link
http://www.contextures.com/xlcomments03.html
On Fri, Aug 19, 2011 at 4:11 PM, N Pradhan wrote:
> **
> Hi,
>
> How do you copy Cell Comments, Please help.
>
> Regards.
>
> --
>
> --
Try This
Public Cmt As Comment
Sub CopyComment()
Set Cmt = ActiveCell.Comment
End Sub
Sub PasteComment()
ActiveCell.AddComment Cmt.Text
CommentText = ""
End Sub
Press Shift+ctrl+C To Copy Comment
Press Shift+Ctrl+V to Paste Comment
From: excel-macros@googlegroups.com [m
1. Copy the cell and Right Click > Paste Special > Comments in another cell.
This will put the same comment in another cell.
2. If you want to paste the text of comment in another cell, use the below
code. This will copy the cell comment and paste it in adjacent cell.
(Comment in A3 is pasted in B3
Dear Pradhan,
Just Simple copy of Comment Cell and Paste it through Special Paste
and Check Comments Option
Step.
Copy-Special Paste-Click on Comments Check Box
On Fri, Aug 19, 2011 at 4:11 PM, N Pradhan wrote:
> **
> Hi,
>
> How do you copy Cell Comments, Please help.
>
> Regards.
