22

More than 5 years have passed since last update.

セルの値からURLを抽出

Excel

Last updated at 2014-09-21Posted at 2014-09-21

マクロ

参考: エクセルでハイパーリンクのＵＲＬだけを文字抽出したい - オフィス系ソフト - 教えて！goo

マクロ登録

Public Sub GetURL()
    Dim h As Hyperlink
    For Each h In ActiveSheet.Hyperlinks
        h.Range.Offset(0, 1) = h.Address
    Next
End Sub

準備

実行結果

22

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

22