top of page

Excel - List a Hyperlink in a Cell


This is a useful little macro. It could be of use when you have documents hyperlinked in an Excel column and need to copy them elsewhere. Once you have the addresses of the links, you can do so in a batch file.

To get the address of the hyperlinks listed in an Excel column, enter this macro in a VBA module:

Public Function GetURL(c As Range) As String

On Error Resume Next

GetURL = c.Hyperlinks(1).Address

End Function

Then put this formula, =GetURL(A1) in a cell, where the link you need is listed in cell A1.

Special thanks to Ellesa who posted this macro at:


 
 

Recent Posts

See All
How does Relativity use AI data?

How is data generated by aiR utilized by Relativity? Relativity has published a white paper addressing its AI security policies assuring...

 
 

Sean O'Shea has more than 20 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

​

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

​

If you have a question or comment about this blog, please make a submission using the form to the right. 

Your details were sent successfully!

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

bottom of page