+ Reply to Thread
Results 1 to 3 of 3

Calling Named Range Not Loading Picture

  1. #1
    Forum Contributor
    Join Date
    04-19-2010
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    150

    Calling Named Range Not Loading Picture

    Hi

    I have a list of countries with their flags (as images) which I have referenced in a NamedRange.

    On another worksheet I am calling the NamedRange which loads the data in cells except the images are not loaded (only the data behind the image in the image cell is loaded).

    Is it possible to load images as well? I have attached my dummy sheet so you know what I mean.

    Appreciate any help here.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,375

    Re: Calling Named Range Not Loading Picture

    You can't with range alone.

    There are several ways to do it.

    1. Using camera tool. This is easiest to set up. But the result will be just image and you can't reference it. See attached sample.
    Link for more details on camera tool. https://trumpexcel.com/excel-camera-tool/

    Edit: Oh and there would be bit of image degradation with above.

    2. Using image lookup. This method requires you to set up blank image shapes before hand.
    Link for this method. https://trumpexcel.com/picture-lookup/

    3. Much like above, but instead of having blank image set up... use vba to generate result.
    Attached Files Attached Files
    Last edited by CK76; 06-05-2020 at 03:19 PM.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    04-19-2010
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    150

    Re: Calling Named Range Not Loading Picture

    Thanks CK76.

    I actually knew about the camera tool but I need to reference the results so that no option is no good.

    On my master file I have tons of pictures so would I have to set up tons of blank images? If so, don't really want to do that.

    Is the VBA option easy to do ? Could you help me here?

    Thanks again

+ 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] Resize picture before loading it into an activex image control
    By Alex Piotto in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-14-2018, 11:34 AM
  2. [SOLVED] Picture as part of a named range
    By Stumped123 in forum Excel General
    Replies: 4
    Last Post: 03-04-2013, 02:31 PM
  3. syntax for loading picture in spreadsheet to imagebox
    By aaronkoh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-15-2013, 04:48 AM
  4. Calling named range from external workbook
    By Phraedrique in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2009, 06:36 PM
  5. Calling Picture Files
    By LevinTrueno in forum Excel General
    Replies: 1
    Last Post: 10-13-2008, 02:54 PM
  6. Picture loading in image problem
    By hunsnowboarder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2008, 11:36 AM
  7. Timing when loading a picture
    By Troubled User in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2006, 09:40 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