Excel macro to list all hyperlinks on a worksheet
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