Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Macro for Pasting Comments into Cells

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Mike T.
    Posts
    180
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a List of Rows approximately 500 Rows Long in Column A. Each cell has a different Comment which is adjacent in Col B, same Row. I want to run a Macro or something that will Insert the Definition (Col B) into each respective cell's Comment in Col A, including Formatting the Comment if possible. Right now, I have to go through the Menu one at a time.
    Thanks for the help.

  2. #2
    Guest

    Default

    Dim intCnt As Integer
    intCnt = 1
    With ActiveSheet
    Do Until .Cells(intCnt, 1) = ""
    .Cells(intCnt, 1).AddComment.Text .Cells(intCnt, 2).Value
    intCnt = intCnt + 1
    Loop
    End With

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Mike T.
    Posts
    180
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi: I copied and pasted this into a macro sheet and nothing happened. Where do you start on the actual worksheet? Do you select the cell that has the Comment and Run or, do you select the cell that has the comment info then run?

    Thanks

  4. #4
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-15 16:51, Henry wrote:
    Hi: I copied and pasted this into a macro sheet and nothing happened. Where do you start on the actual worksheet? Do you select the cell that has the Comment and Run or, do you select the cell that has the comment info then run?

    Thanks
    Hi Henry
    I believe you have to select the start of
    your data in column A then run his macro.


    Ivan

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Friend,

    Download a small file commentpasting from my website. It is in download section

    http://www.pexcel.com/download.htm

    ni****h desai

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •