replace link
Sun, 29 May 2016 - 2:48 AM
Hi,
I would like to create a macro that updates links in my spreadsheet.
Basically, I would like to do a loop for each link on the sheet and do an update of the links…
for example: if I have a hyperlink cell named “ITEM” that links to “E: /product_1.jpg”,
macro will change this link to “W: /product_1.jpg”
Of course W is a variable that I will change before launching the macro..
So, once can be E, then K, then H, etc..
I think to use “createEnumeration” to cycle each single link.. and then replace it..
But I do not know how to do.
thanks for suggestions
C.
Sun, 29 May 2016 - 4:18 PM
#2
Hi mark_t
I saw this feature
Hi mark_t
I saw this feature HYPERLINK,
but I can not figure out how to iterate all hyperlinks on the sheet..
thanks a lot
With the following A1 is the cell where you would put “w”, “e” etc.
Maybe use cell formatting to make it obvious to user that the cell contains a hyperlink, eg underlined blue text.