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