copy comment content to cell content as data not as comment
How do I copy comment content to cell content as data and not as comment?
|
copy comment content to cell content as data not as comment
Say you have a comment in Cell C6 and A1 is your Target for the Comment text
Sub foo() Range("A1").Value = Application.Range("C6").Comment.Text End Sub "Lilach" wrote: How do I copy comment content to cell content as data and not as comment? |
copy comment content to cell content as data not as comment
You have to use a macro:
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 Lilach wrote: How do I copy comment content to cell content as data and not as comment? -- Dave Peterson |
All times are GMT +1. The time now is 03:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com