+ Reply to Thread
Results 1 to 7 of 7

Multiple Comments using VBA

  1. #1
    Forum Contributor
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    200

    Multiple Comments using VBA

    I am using the below code in the attached worksheet to add comments in a few different cells. I can't get it to work once the source row becomes double digits (10+). Any help would be appreciated. Thank you!

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Multiple Comments using VBA

    Instead of using Like use Intersect, for example.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    200

    Re: Multiple Comments using VBA

    I got Compile error. Expected: List Separator or )

  4. #4
    Forum Contributor
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    200

    Re: Multiple Comments using VBA

    I figured it out. Thankyou so much.

  5. #5
    Forum Contributor
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    200

    Re: Multiple Comments using VBA

    It did work but whenever I made a change to one of the source cells (I3), I got a Compile Error: End If without Block If. ??

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Multiple Comments using VBA

    Can you post the current code?

  7. #7
    Forum Contributor
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    200

    Re: Multiple Comments using VBA

    I figured it out. I was missing an End With. Thank you soooo much!

+ 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. Multiple entries for 'comments' within the same row
    By ma701ss in forum Excel General
    Replies: 2
    Last Post: 09-16-2015, 05:57 PM
  2. [SOLVED] Add multiple comments to a cell.
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-09-2015, 03:17 PM
  3. [SOLVED] Change Size of Multiple Comments
    By dompoma in forum Excel General
    Replies: 15
    Last Post: 04-12-2013, 01:46 AM
  4. Comments in multiple cells
    By mweiss1215 in forum Excel General
    Replies: 0
    Last Post: 07-25-2011, 10:55 AM
  5. Extract comments to multiple rows
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-02-2009, 03:27 PM
  6. Replies: 3
    Last Post: 08-14-2009, 07:22 AM
  7. Showing Multiple Comments
    By kttrail in forum Excel General
    Replies: 2
    Last Post: 11-01-2007, 12:23 PM

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