If you work with an Excel workbook that contains many hyperlinks across many worksheets, and you want to create a report to list out the information of each hyperlink, doing that manually sounds crazy to me (I have seen that in real live that actually happened…).

That’s why in this tutorial, I am going to share a simple VBA script that will generates a new worksheet and list out all the hyperlinks’ information (Display Text, Address, and Sub-Address).

VBA Script