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)
--------------------------------------- Sub CopyCommentText() Dim CmtText As String Dim CmtCount As Integer, i As Integer Dim CommCell As String CmtCount = ActiveSheet.Comments.Count For i = 1 To CmtCount CommCell = ActiveSheet.Comments(i).Parent.Address Range(CommCell).Offset(0, 1) = ActiveSheet.Comments(i).Text Next i End Sub -------------------------- Hope this helps. AJ On Fri, Aug 19, 2011 at 4:11 PM, N Pradhan <nalini.pradha...@gmail.com>wrote: > ** > Hi, > > How do you copy Cell Comments, Please help. > > Regards. > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel