{"id":5686,"date":"2022-03-03T08:06:27","date_gmt":"2022-03-03T08:06:27","guid":{"rendered":"https:\/\/lacotasu.com\/?p=5686"},"modified":"2022-03-03T08:07:19","modified_gmt":"2022-03-03T08:07:19","slug":"%e3%80%90url%e3%83%95%e3%83%a9%e3%82%b0%e3%83%a1%e3%83%b3%e3%83%88%e3%80%91excel%e3%81%a7gethyperlink%e9%96%a2%e6%95%b0%e4%bd%9c%e3%81%a3%e3%81%9f%e3%81%91%e3%81%a9url%e3%81%ab%ef%bc%83%e3%81%8c","status":"publish","type":"post","link":"https:\/\/lacotasu.com\/?p=5686","title":{"rendered":"\u3010URL\u30d5\u30e9\u30b0\u30e1\u30f3\u30c8\u3011Excel\u3067GetHyperlink\u95a2\u6570\u4f5c\u3063\u305f\u3051\u3069URL\u306b\uff03\u304c\u5165\u3063\u3066\u308b\u3068\uff03\u4ee5\u964d\u304c\u30b2\u30c3\u30c8\u3067\u304d\u306a\u3044\u4ef6\u3092\u89e3\u6c7a\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"\n<p>Excel\u3092\u958b\u3044\u305f\u72b6\u614b\u3067Alt + F11<\/p>\n\n\n\n<p>\u633f\u5165\u2192\u6a19\u6e96\u30e2\u30b8\u30e5\u30fc\u30eb<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"571\" height=\"421\" src=\"https:\/\/lacotasu.com\/wp-content\/uploads\/2022\/03\/image-8.png\" alt=\"\" class=\"wp-image-5689\" srcset=\"https:\/\/lacotasu.com\/wp-content\/uploads\/2022\/03\/image-8.png 571w, https:\/\/lacotasu.com\/wp-content\/uploads\/2022\/03\/image-8-300x221.png 300w\" sizes=\"auto, (max-width: 571px) 100vw, 571px\" \/><\/figure>\n\n\n\n<p>\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u8cbc\u308a\u4ed8\u3051\u308b\u3002\uff08Function \u304b\u3089 End Function\u307e\u3067\uff09<\/p>\n\n\n\n<p>Function GetHyperlink(\u30bb\u30eb As Range) As String<br>  Dim sp As Shape<br>  If \u30bb\u30eb.Hyperlinks.Count &gt; 0 Then<br>    GetHyperlink = <strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">\u30bb\u30eb.Hyperlinks(1).Address<\/mark><\/strong> &amp; \"#\" &amp; <strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">\u30bb\u30eb.Hyperlinks(1).SubAddress<\/mark><\/strong><br>  End If<br>  For Each sp In ActiveSheet.Shapes<br>    If \u30bb\u30eb.Address = sp.TopLeftCell.Address Then<br>      GetHyperlink = GetHyperlink &amp; vbLf &amp; sp.Hyperlink.Address<br>    End If<br>  Next<br>End Function<\/p>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">\u30bb\u30eb.Hyperlinks(1).Address<\/mark><\/strong>\u3000\u2190\uff03\u3088\u308a\u524d\u3092\u53d6\u5f97\u3067\u304d\u308b<\/p>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">\u30bb\u30eb.Hyperlinks(1).SubAddress<\/mark><\/strong>\u3000\u2190\uff03\u3088\u308a\u5f8c\u308d\u3092\u53d6\u5f97\u3067\u304d\u308b<\/p>\n\n\n\n<p>\u2193GetHyperlink\u95a2\u6570\u304c\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u308b<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"320\" height=\"269\" src=\"https:\/\/lacotasu.com\/wp-content\/uploads\/2022\/03\/image-9.png\" alt=\"\" class=\"wp-image-5692\" srcset=\"https:\/\/lacotasu.com\/wp-content\/uploads\/2022\/03\/image-9.png 320w, https:\/\/lacotasu.com\/wp-content\/uploads\/2022\/03\/image-9-300x252.png 300w\" sizes=\"auto, (max-width: 320px) 100vw, 320px\" \/><\/figure>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u4ee5\u4e0a<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel\u3092\u958b\u3044\u305f\u72b6\u614b\u3067Alt + F11 \u633f\u5165\u2192\u6a19\u6e96\u30e2\u30b8\u30e5\u30fc\u30eb \u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u8cbc\u308a\u4ed8\u3051\u308b\u3002\uff08Function \u304b\u3089 End Function\u307e\u3067\uff09 Function GetHyperlink(\u30bb\u30eb  ... <\/p>\n","protected":false},"author":1,"featured_media":5693,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5686","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/lacotasu.com\/index.php?rest_route=\/wp\/v2\/posts\/5686","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lacotasu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lacotasu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lacotasu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lacotasu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5686"}],"version-history":[{"count":6,"href":"https:\/\/lacotasu.com\/index.php?rest_route=\/wp\/v2\/posts\/5686\/revisions"}],"predecessor-version":[{"id":5695,"href":"https:\/\/lacotasu.com\/index.php?rest_route=\/wp\/v2\/posts\/5686\/revisions\/5695"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lacotasu.com\/index.php?rest_route=\/wp\/v2\/media\/5693"}],"wp:attachment":[{"href":"https:\/\/lacotasu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lacotasu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5686"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lacotasu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}