Forum Discussion
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...
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.