If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how can we copy cells comments text and paste to cells
|
#2
|
|||
|
|||
how can we copy cells comments text and paste to cells
http://www.mrexcel.com/archive/Edit/11076.html
"?? ???" wrote in message ... How can I copy comments text and paste into cells (for a full column of thousands of rows, with hundreds of comments) -- Shai email: |
#3
|
|||
|
|||
how can we copy cells comments text and paste to cells
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 ?? ??? wrote: How can I copy comments text and paste into cells (for a full column of thousands of rows, with hundreds of comments) -- Shai email: -- Dave Peterson |
#4
|
|||
|
|||
how can we copy cells comments text and paste to cells
select the column you want select "copy" go to where you want to paste - select PASTE - Then SPECIAL and select what you want to paste. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.hightechtalks.com/m390 View this thread: http://www.hightechtalks.com/t2306167 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking text boxes | Volunteer Mom | Publisher | 7 | November 12th, 2008 01:29 AM |
Very useful to be able to copy & paste text in error dialogue box | Marten Tieleman | General Discussions | 2 | May 25th, 2005 12:49 AM |
How do you copy and paste into an *existing* text box in Publisher | Judi | Publisher | 2 | November 18th, 2004 05:15 PM |
Copy cells and paste them as images in another sheet | Michael Cantinotti | General Discussion | 6 | November 7th, 2004 06:46 PM |
Text boxes-help | Jon Peltier | Charts and Charting | 0 | January 26th, 2004 05:46 PM |