how can we copy cells comments text and paste to cells

How can I copy comments text and paste into cells (for a full column of
thousands of rows, with hundreds of comments)
--
Shai
email:

http://www.mrexcel.com/archive/Edit/11076.html

"?? ???" wrote in message
...
How can I copy comments text and paste into cells (for a full column of
thousands of rows, with hundreds of comments)
--
Shai
email:

Saved from a previous post:

You can retrieve the text from a comment with a userdefined function like:

Option Explicit
Function GetComment(FCell As Range) As Variant
Application.Volatile

Set FCell = FCell(1)

If FCell.Comment Is Nothing Then
GetComment = ""
Else
GetComment = FCell.Comment.Text
End If

End Function

Then you can use it like any other function:

=getcomment(a1)

But be aware that the function won't evaluate when you just change the comment.
It'll be correct when excel recalculates. (Hit F9 to force a recalc.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

?? ??? wrote:

How can I copy comments text and paste into cells (for a full column of
thousands of rows, with hundreds of comments)
--
Shai
email:

--

Dave Peterson

select the column you want select "copy" go to where you want to paste -
select PASTE - Then SPECIAL and select what you want to paste.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2306167