+ Reply to Thread
Results 1 to 2 of 2

Contents from range to comments

  1. #1
    Registered User
    Join Date
    09-17-2012
    Location
    Netherlands
    MS-Off Ver
    Office 2010 Plus
    Posts
    15

    Contents from range to comments

    Hello!

    I would like the contents of a cell to be inserted as a comment. Now I've seen a few examples that work, but they only work on selection or for a single cell.

    These are the cell ranges that have information that I want to have inserted as a comment in the same cell. C5:AG5, C10:AG10, C15:AG15 and so on, all the way up to C170:AG170.

    I'd like for it to automatically search for any cells(in specified range above) that have been changed(worksheet wide) and add it to the comments. However empty cells are not to be commented.

    Was hoping any of you have some example code laying around that could make this work or at least point me in the right direction.

    Added a example workbook in case it's not clear, no code included.



    Any help is much appreciated, thank you in advance.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-17-2012
    Location
    Netherlands
    MS-Off Ver
    Office 2010 Plus
    Posts
    15

    Re: Contents from range to comments

    Anyone?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy & Paste Cell Contents into Comments in another range of cells
    By Barking_Mad in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-12-2015, 06:38 PM
  2. [SOLVED] Function to match contents of comments ?
    By elgato74 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-27-2014, 08:28 PM
  3. Cell contents to comments
    By phil2006 in forum Excel General
    Replies: 8
    Last Post: 02-07-2014, 02:03 PM
  4. Excel 2007 : Listing comments and cell contents
    By MSP in forum Excel General
    Replies: 2
    Last Post: 12-30-2010, 11:53 AM
  5. Contents to Comments, Cumulative
    By Lambs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-02-2006, 04:20 PM

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