Search

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


27 views

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com