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
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.
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks