+ Reply to Thread
Results 1 to 3 of 3

VBA add comment to range of cells

  1. #1
    Registered User
    Join Date
    07-02-2012
    Location
    hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    40

    VBA add comment to range of cells

    WHen i try to add comment to range of cells, i am facing error.
    can any one do help on this.

    rng.AddComment "Comment"

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: VBA add comment to range of cells

    Delete the existing comment and try...

    Use error handler to suppress the error when the cells doesn't have comment.

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: VBA add comment to range of cells

    as per my knowledge u can add comment to singel cell only

    at a time to a ranges of cells u cant add comments

    for single cell
    Please Login or Register  to view this content.
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

+ 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. Disable Delete Comment, Edit Comment, Show/Hide Comment
    By Shanthan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2013, 06:12 AM
  2. Get the range name from a comment
    By qadirv in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-30-2013, 08:51 AM
  3. Insert a range of cells that match a criteria to be returned as a cell comment
    By Wdiaz007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-13-2012, 05:09 PM
  4. open a comment to cell range upon true condition then removing comment on false condition
    By ferrum_equitis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 12:55 AM
  5. [SOLVED] Range's comment text
    By Mircea Pleteriu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2005, 07:06 AM

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