New ResponseCancelCopy to Archive Copy to ArchiveMove to Archive Move to Archive

Document Library
Main Topic

Kurt Tomicich
2014/12/15


Procedure
Subject:Excel - Extract URL from Hyperlinks
Category:Software\ Microsoft Office
Version:
Revision Date:2014/12/15 Modified: 2014/12/15
 
OriginatorReviewers
Kurt Tomicich
Create a macro:
Sub ExtractHL()
   Dim HL As Hyperlink
   For Each HL In ActiveSheet.Hyperlinks
       HL.Range.Offset(0, 1).Value = HL.Address
   Next
End Sub



All Documents   By Author   By Category   By Alternate Name   Review Status   Help