Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move Comment into cell as Text
How do I move comments into cells as text?
or use vlookup to pull comment to another sheet? -- Just Computing |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move Comment into cell as Text
Select some cells and run this macro:
Sub CommentMover() Dim r As Range For Each r In Selection On Error Resume Next Set C = r.Comment If Err.Number = 0 Then r.Offset(0, 1).Value = r.Comment.Text End If On Error GoTo 0 Next End Sub If one of the selected cells contains a comment, the text will be copied into the cell immediately to the right. -- Gary''s Student - gsnu200812 "Frances" wrote: How do I move comments into cells as text? or use vlookup to pull comment to another sheet? -- Just Computing |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move Comment into cell as Text
Worked Wonderfully.
-- Just Computing "Gary''s Student" wrote: Select some cells and run this macro: Sub CommentMover() Dim r As Range For Each r In Selection On Error Resume Next Set C = r.Comment If Err.Number = 0 Then r.Offset(0, 1).Value = r.Comment.Text End If On Error GoTo 0 Next End Sub If one of the selected cells contains a comment, the text will be copied into the cell immediately to the right. -- Gary''s Student - gsnu200812 "Frances" wrote: How do I move comments into cells as text? or use vlookup to pull comment to another sheet? -- Just Computing |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move comment into cell as text | Excel Discussion (Misc queries) | |||
Create Cell Comment based on text in a cell on another worksheet | Excel Discussion (Misc queries) | |||
How do I move comment indicator to different corner of cell? | Excel Worksheet Functions | |||
How can I move the comment box to the left of the cell? | Excel Worksheet Functions | |||
How can I translate a comment to text in a cell? | Excel Discussion (Misc queries) |