+ Reply to Thread
Results 1 to 6 of 6

How can i edit a cell comment..?

Hybrid View

  1. #1
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: How can i edit a cell comment..?

    try this:

    For j = 2 To v + 1
    ' Sheets("Sheet1").Select
    fault = Cells(j, 19).Value
    Affecser = Cells(j, 15).Value
    If Not Cells(j, col).Comment Is Nothing Then
        myStr = Cells(j, col).Comment.Text
        Cells(j, col).Comment.Delete
        Cells(j, col).AddComment.Text myStr & Chr(10) & fault & "(" & Affecser & ")"
    End If
    Next j
    If a cell has a comment, the new text will be appended in a new line. If a cell does not have a comment, it will be skipped, i.e. no comment will be added.

    cheers

  2. #2
    Registered User
    Join Date
    09-30-2010
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    22

    Smile Re: How can i edit a cell comment..?

    Thanx for ur reply...its working...

+ 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