| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Cell Comments and Paste as text in a cell
Perfect - thank you
"Gary''s Student" wrote: Select the cells in question and run nthis small macro: Sub comment_setter() Dim r As Range, rr As Range On Error Resume Next Set r = Selection.SpecialCells(xlCellTypeComments) If r Is Nothing Then MsgBox ("no comments found") Exit Sub End If For Each rr In r rr.Value = rr.comment.Text Next End Sub -- Gary''s Student - gsnu200907 "Goaliemenace" wrote: Is there an easier function/process to copy cell comments and paste directly into a cell as text, without having to edit the comment first and select the required text manually? Copy and paste comments does not work, it merely keeps the same character when pasted into a new cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract text from cell | Excel Worksheet Functions | |||
| how to cut part of a text from one cell and automatically paste itonto another cell | Excel Discussion (Misc queries) | |||
| Extract Cell Comments/Notes to data | Excel Discussion (Misc queries) | |||
| Extract Comments and paste as values | Excel Discussion (Misc queries) | |||
| Paste Link - Cell Comments get lost | Excel Worksheet Functions | |||
Threaded Mode
