Excel macro to list all hyperlinks on a worksheet

Excel macro to list all hyperlinks on a worksheet

July 26, 2016

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

 

 

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

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