Excel macro to list all hyperlinks on a worksheet
- Sean O'Shea
- Jul 26, 2016
- 1 min read
If you have a spreadsheet with hyperlinks in several different columns you can use the macro posted to this site to get a quick list of all of them.
Click on the little 'view source' icon to the upper right of the code [the little picture of a page with blue arrows] so you can copy it out cleanly:

Then press ALT + F11 and insert the code in a module

. . . if you have a spreadsheet with hyperlinks scattered about in different cells . . .

. . . you can use the macro to get an orderly list of the hyperlinks
