Prev: Pivot Table Filter Formula
Next: Send a Sheet as body of Outlook Email
From: Sue on 19 Mar 2010 09:16
My admin put data into comments instead of a seperate column. How can I
move/copy/convert that data from a comment to the contents of a cell?
From: Jacob Skaria on 19 Mar 2010 09:26
Try this UDF (User Defined function). From workbook launch VBE using Alt+F11.
From menu Insert a Module and paste the below function.Close and get back to
workbook and try the below formula.

=GetComments(A1)

Function GetComments(rngTemp As Range)
If Not rngTemp.Comment Is Nothing Then
GetComments = rngTemp.Comment.Text
End If
End Function

The formula wil have to be recalculated when you change the comments;

--
Jacob


"Sue" wrote:

> My admin put data into comments instead of a seperate column. How can I
> move/copy/convert that data from a comment to the contents of a cell?
 | 
Pages: 1
Prev: Pivot Table Filter Formula
Next: Send a Sheet as body of Outlook Email