Forum Discussion
AR-DA950
Nov 13, 2022Copper Contributor
Extract URL from hyperlink formula
i have an excel file with many URLs linked to a word with the format HYPERLINK(url, [link_label]). I tried running a VBA code to open all the URLs at once but this is not working. Same code works for...
JKPieterse
Nov 14, 2022Silver Contributor
You should look at the formula itself, it probably takes the URL from one or more adjacent cells. Read those cells to reconstruct the url the HYPERLINK formula uses.