+ Reply to Thread
Results 1 to 4 of 4

Insert Contents of a Cell Range into a single Excel Comment

  1. #1
    Registered User
    Join Date
    01-21-2009
    Location
    Nanning, China
    MS-Off Ver
    Excel 2003
    Posts
    12

    Insert Contents of a Cell Range into a single Excel Comment

    Hello
    I would like to Insert the contents of a Range of Cells into a single Comment. ie:
    The contents of Range A1:A50 into a Comment placed at F1. Is there a Macro that will do this? Thanks All
    Last edited by ChinaReg; 02-17-2009 at 02:37 AM.

  2. #2
    Chris Bode
    Guest

    Re: Insert Contents of a Cell Range into a single Excel Comment

    Use this code

    Sheet1.Cells(1, 1).AddComment ("dsad")

    Chris
    Last edited by VBA Noob; 02-15-2009 at 06:27 AM.

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Insert Contents of a Cell Range into a single Excel Comment

    Chris, I don't think that will suffice.

    Perhaps:

    Please Login or Register  to view this content.
    You may have issues pending length of strings in your 50 cells.

  4. #4
    Registered User
    Join Date
    01-21-2009
    Location
    Nanning, China
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Insert Contents of a Cell Range into a single Excel Comment

    Thank you DonkeyOte and Chris for your replies. DonkeyOte, your answer works perfectly for my needs. I'll mark this one Solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1