+ Reply to Thread
Results 1 to 2 of 2

CELCOM with Pictures

  1. #1
    Registered User
    Join Date
    03-19-2021
    Location
    Kitchener, Ontario
    MS-Off Ver
    MS Office 2016
    Posts
    8

    CELCOM with Pictures

    I want to copy "Comments" from one sheet to another, but all of the comments are actually Pictures.

    So far, the below works for text - and I tried changing to: rgCELL.Comment.Picture .... but that didn't work.

    Public Function CELCOM(rgCELL As Range) As String
    On Error GoTo NO_COMMENT
    CELCOM = "Comment in " & _
    rgCELL.Address(False, False) & _
    ":= " & _
    rgCELL.Comment.Text
    NO_COMMENT:
    End Function

    Is there another way to get the picture comments to copy over?

  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,436

    Re: CELCOM with Pictures

    Suspect you'd need to copy the cell itself and delete the cell content if necessary.
    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


+ 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. Replies: 3
    Last Post: 01-19-2018, 09:17 AM
  2. How to remove hyperlink to pictures in excel and retain the pictures?
    By london7871 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2016, 11:24 PM
  3. Replies: 1
    Last Post: 05-02-2014, 06:18 AM
  4. Project management and pictures, basically make a day planner with pictures
    By Axe Doctor in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-10-2012, 12:58 PM
  5. Insert/Delete Multiple Pictures but 1 or more pictures not available
    By MrNoodles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2012, 02:10 PM
  6. Replies: 2
    Last Post: 07-11-2006, 01:35 PM
  7. Replies: 1
    Last Post: 01-29-2006, 02:50 AM

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