| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments into a cell without VB.
Neat!!
"Gary''s Student" wrote: You are correct, but some people are shy of VBA. This small routine will run down column A, grab any comments, and append them to the data already in the cell: Sub xrf_cmts() For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row Set r = Cells(i, 1) Set cmt = r.Comment If cmt Is Nothing Then Else s = cmt.Text r.Value = r.Text & s End If Next End Sub -- Gary''s Student gsnu200711 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print comments using cell contents, not cell# | Excel Discussion (Misc queries) | |||
| Cell Comments | Excel Discussion (Misc queries) | |||
| Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
| Comments in cell | Excel Discussion (Misc queries) | |||
| cell comments | Excel Worksheet Functions | |||
Threaded Mode
