Converting A Hyperlink To Plain Text Using VBA
If you want to use VBA code to solve a problem, you can do the following steps:
1. Press F11+Alt keys simultaneously to open the Microsoft Visual Basic for Applications window.
2. Click Insert > The module show the new widow Module, and then paste the VBA code below into the Module window.
VBA: Converting hyperlinks to plain text.
2 3 4 5 6 | Sub ExtractHL() Dim HL As Hyperlink For Each HL In ActiveSheet.Hyperlinks HL.Range.Offset(0, 1).Value = HL.Address Next End Sub |
3. Press the F5 key or click the Run button to execute this VBA, then all hyperlinks on the entire sheet have been converted to plain text.
Note: With this VBA, all hyperlinks on the current sheet will be converted to plain text.
