+ Reply to Thread
Results 1 to 4 of 4

Identify comments

  1. #1
    Registered User
    Join Date
    05-07-2021
    Location
    Naples, Italy
    MS-Off Ver
    Office 2016
    Posts
    30

    Identify comments

    Hey!

    I was wondering if there is a way to identify a comment, just like for shapes, so that I can delete it using its name.


    Many thanks in advance for all your tips!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,377

    Re: Identify comments

    See: https://www.contextures.com/xlcomments03.html
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    05-07-2021
    Location
    Naples, Italy
    MS-Off Ver
    Office 2016
    Posts
    30

    Re: Identify comments

    Brilliant!

    Thanks

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,377

    Re: Identify comments

    You're welcome.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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] Everything about comments - especially how to create blank comments
    By paradocs in forum Excel General
    Replies: 3
    Last Post: 01-12-2020, 04:08 AM
  2. column comparison, trying to identify identify identical columns.
    By Jowel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-24-2014, 04:12 AM
  3. Append comments to a cell which already has comments
    By seanpears99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2013, 07:34 PM
  4. Add comments to cells using VBA (comments from list)
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-15-2010, 12:11 PM
  5. Replies: 3
    Last Post: 08-14-2009, 07:22 AM
  6. Adding comments & deleting comments VBA
    By tian0020 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2007, 08:35 PM
  7. [SOLVED] Cell Comments-Is possible to search for data in comments?
    By dmm129 in forum Excel General
    Replies: 3
    Last Post: 10-28-2005, 03:05 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