Hyperlink Multiple Images At Once?

Hi all,

I am completely stumped with this problem and not sure where to begin.

I have about 20,000 hyperlinks in my excel sheet that I would like to assign to individual images.

For example, how do I link an image in cell A2, using a hyperlink from cell B2?

I know that if I wanted to simply hyperlink text, I would use =HYPERLINK(B2,"text"), but this reference won't work for images.

I also know I can right click on the image and insert a hyperlink that way, but this obviously isn't practical because I am working with over 20,000 links.

Any help would be appreciated with figuring out this monster of a task, thank you in advance!

Do the shape numbers correlate in any way with the row numbers? If so, it should be possible to create a macro loop using a construct similar to ..

Please Login or Register  to view this content.

Hello vegas12,

Do want hyperlinks in column "A" or only the friendly text? Does not make much sense to have hyperlinks in one column and pictures with the same hyperlinks in the adjacent column.

If you want to add the cell contents in col A to the images in col B as hyperlinks,

Please Login or Register  to view this content.

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes

Originally Posted by mah.saleh83

Hi All,

I have the same issue as "vegas12" with one extra request, where I have to send the hyperlinked images using Mail Merge to all those who are in the list, i.e. each person should receive the assigned image for him and the image should contain the hyperlink assigned for him. any thoughts?

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread