+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Macro to send the cell contents of a column to the previous column as comments.

  1. #1
    Registered User
    Join Date
    07-04-2010
    Location
    Qld, Australia
    MS-Off Ver
    Excel 2007
    Posts
    12

    Macro to send the cell contents of a column to the previous column as comments.

    Hi, I am hoping someone can help me with a macro for Excel 2007. I wish to "reverse" the following macro, so that it sends the contents of an entire column (in this case the second column) back to the previous column as Cell Comments, without interfering with the contents of the cells.
    Please Login or Register  to view this content.
    Last edited by davesexcel; 05-16-2012 at 09:45 PM.

  2. #2
    Forum Contributor
    Join Date
    06-09-2011
    Location
    Germany
    MS-Off Ver
    Excel 2016
    Posts
    193

    Re: Macro to send the cell contents of a column to the previous column as comments.

    Hi ILM234,

    try this one please:

    Please Login or Register  to view this content.
    The macro will take all calues from Column B (=ColumnNumber 2) and will copy the information into the comments of Column A

    Regards

    Theo
    _____________
    If your are statisfied by the solution provided then PLEASE CLICK THE STAR icon.
    If the problem is resolved, pls mark your thread as SOLVED.

  3. #3
    Registered User
    Join Date
    07-04-2010
    Location
    Qld, Australia
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Macro to send the cell contents of a column to the previous column as comments.

    Thank you! This works perfectly. You also answered my second question, which was how to apply this macro to other columns? This can easily be done by changing the letters and numbers in line #7 of the above code. Theo, you are a legend! This one is SOLVED!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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