{"id":2435,"date":"2019-06-26T09:55:14","date_gmt":"2019-06-26T00:55:14","guid":{"rendered":"https:\/\/thirtiesprogrammer.com\/?p=2435"},"modified":"2019-06-26T09:55:14","modified_gmt":"2019-06-26T00:55:14","slug":"%e9%80%9a%e4%bf%a1%e6%95%99%e8%82%b2%e3%81%a7excelvba%e3%82%92%e5%ad%a6%e3%81%b3%e3%80%81%e6%a5%ad%e5%8b%99%e3%82%92%e5%8a%b9%e7%8e%87%e5%8c%96%e3%81%97%e3%81%9f%e8%a9%b1%e3%81%97","status":"publish","type":"post","link":"https:\/\/thirtiesprogrammer.com\/?p=2435","title":{"rendered":"\u901a\u4fe1\u6559\u80b2\u3067ExcelVBA\u3092\u5b66\u3073\u3001\u696d\u52d9\u3092\u52b9\u7387\u5316\u3057\u305f\u8a71\u3057"},"content":{"rendered":"<p><img class=\"aligncenter size-full wp-image-2449\" src=\"https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2019\/06\/eDHLr40g_6tES7x1561505564_1561505619.jpg\" alt=\"\u901a\u4fe1\u6559\u80b2\u3067 Excel VBA\u3092\u5b66\u3073\u3001\u696d\u52d9\u3092\u52b9\u7387\u5316\u3057\u305f\u8a71\u3057\" width=\"640\" height=\"480\" srcset=\"https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2019\/06\/eDHLr40g_6tES7x1561505564_1561505619.jpg 640w, https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2019\/06\/eDHLr40g_6tES7x1561505564_1561505619-300x225.jpg 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>\u79c1\u304cExcelVBA\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u3092\u5b66\u307c\u3046\u3068\u3057\u305f\u969b\u3001\u307e\u305a\u306f\u5927\u624b\u4f01\u696d\u304c\u884c\u3063\u3066\u3044\u308b<strong>\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u306e\u901a\u4fe1\u6559\u80b2<\/strong>\u3092\u53d7\u3051\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u305f\u307e\u305f\u307e\u30ad\u30e3\u30f3\u30da\u30fc\u30f3\u4e2d\u3067<span class=\"huto\">\u534a\u984d\u30ad\u30e3\u30c3\u30b7\u30e5\u30d0\u30c3\u30af\u4ed8\u304d<\/span>\u3060\u3063\u305f\u3068\u3044\u3046\u306e\u3082\u7406\u7531\u306e\u3072\u3068\u3064\u3067\u3059\u3002<\/p>\n<p>\u307e\u3041\u3001\u305f\u3060\u30b9\u30af\u30fc\u30eb\u3068\u304b\u306f\u3044\u3064\u3082\u4f55\u3089\u304b\u306e\u30ad\u30e3\u30f3\u30da\u30fc\u30f3\u306f\u3084\u3063\u3066\u3044\u308b\u306e\u3067\u7279\u5225\u5b89\u3044\u308f\u3051\u3067\u306f\u306a\u304b\u3063\u305f\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<div id=\"toc_container\" class=\"toc_light_blue no_bullets\"><p class=\"toc_title\">\u76ee\u6b21<\/p><ul class=\"toc_list\"><li><a href=\"#i\"><span class=\"toc_number toc_depth_1\">1<\/span> \u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u901a\u4fe1\u6559\u80b2\u306e\u5185\u5bb9<\/a><\/li><li><a href=\"#i-2\"><span class=\"toc_number toc_depth_1\">2<\/span> \u4ed5\u4e8b\u5834\u307e\u3067\u30c6\u30ad\u30b9\u30c8\u3092\u6301\u3061\u8fbc\u3093\u3067\u52c9\u5f37<\/a><ul><li><a href=\"#i-3\"><span class=\"toc_number toc_depth_2\">2.1<\/span> \u5e38\u306b\u624b\u5143\u306b\u7f6e\u3044\u3066\u304a\u304f<\/a><\/li><li><a href=\"#i-4\"><span class=\"toc_number toc_depth_2\">2.2<\/span> \u6163\u308c\u306a\u3044\u5185\u5bb9\u306f\u6642\u9593\u304c\u639b\u304b\u3063\u305f<\/a><\/li><\/ul><\/li><li><a href=\"#i-5\"><span class=\"toc_number toc_depth_1\">3<\/span> \u307e\u3068\u3081<\/a><\/li><\/ul><\/div>\n\n<h2><span id=\"i\">\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u901a\u4fe1\u6559\u80b2\u306e\u5185\u5bb9<\/span><\/h2>\n<p><img class=\"aligncenter size-full wp-image-2452\" src=\"https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2019\/06\/eb486e90f3272d919a18e63617555f97_s.jpg\" alt=\"\" width=\"640\" height=\"480\" srcset=\"https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2019\/06\/eb486e90f3272d919a18e63617555f97_s.jpg 640w, https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2019\/06\/eb486e90f3272d919a18e63617555f97_s-300x225.jpg 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u306e\u901a\u4fe1\u6559\u80b2\u3068\u3044\u3063\u3066\u3082\u7279\u5225\u306a\u3053\u3068\u306f\u306a\u304f\u3001\u6559\u6750\u306e\u30c6\u30ad\u30b9\u30c8\u304c\u9001\u3089\u308c\u3066\u6765\u3066\u3001\u305d\u308c\u306b\u57fa\u3065\u3044\u305f\u554f\u984c\u96c6\u304c\u3042\u308b\u7c21\u5358\u306a\u3082\u306e\u3067\u3057\u305f\u3002<\/p>\n<p>\u8ab2\u984c\u306b\u95a2\u3057\u3066\u306f\u90f5\u9001\u3057\u3066\u63a1\u70b9\u3057\u3066\u3082\u3089\u3048\u307e\u3059\u3002<\/p>\n<p>\u53d7\u8b1b\u3057\u305f\u306e\u306fExcel\u306eVBA\u30b3\u30fc\u30b9\u3067\u3057\u305f\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2><span id=\"i-2\">\u4ed5\u4e8b\u5834\u307e\u3067\u30c6\u30ad\u30b9\u30c8\u3092\u6301\u3061\u8fbc\u3093\u3067\u52c9\u5f37<\/span><\/h2>\n<p><img class=\"aligncenter size-full wp-image-1859\" src=\"https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2019\/03\/5f6238bad97b4b3e56654fca9afc9ae1_s.jpg\" alt=\"\" width=\"640\" height=\"427\" srcset=\"https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2019\/03\/5f6238bad97b4b3e56654fca9afc9ae1_s.jpg 640w, https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2019\/03\/5f6238bad97b4b3e56654fca9afc9ae1_s-300x200.jpg 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>\u79c1\u306f\u793e\u4f1a\u4eba\u4e00\u5e74\u76ee\u306b\u3082\u304b\u304b\u308f\u3089\u305a<\/p>\n<div class=\"yellowbox\">\n<p>\u30fb\u30a2\u30f3\u30b1\u30fc\u30c8\u96c6\u8a08<\/p>\n<p>\u30fb\u30a8\u30af\u30bb\u30eb\u3067\u306e\u30c7\u30fc\u30bf\u52a0\u5de5\u7b49<\/p>\n<\/div>\n<p>\u304b\u306a\u308a\u306e\u4ed5\u4e8b\u91cf\u304c\u4e0e\u3048\u3089\u308c\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n<p>\u696d\u52d9\u91cf\u3092\u5c11\u306a\u304f\u3059\u308b\u3079\u304f\u3001\u5fd9\u3057\u3044\u306a\u304c\u3089\u3082\u901a\u4fe1\u6559\u80b2\u306e\u30c6\u30ad\u30b9\u30c8\u3092\u4f1a\u793e\u306b\u6301\u3061\u8fbc\u307f\u3001\u5b9f\u8df5\u5f62\u5f0f\u306b\u3066\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u3092\u52c9\u5f37\u3057\u307e\u3057\u305f\u3002<\/p>\n<h3><span id=\"i-3\">\u5e38\u306b\u624b\u5143\u306b\u7f6e\u3044\u3066\u304a\u304f<\/span><\/h3>\n<p>\u30c6\u30ad\u30b9\u30c8\u304c\u624b\u5143\u306b\u3042\u308b\u3053\u3068\u3067\u3001\u3059\u3050\u306b\u5185\u5bb9\u3092\u78ba\u8a8d\u3067\u304d\u308b\u74b0\u5883\u306b\u3042\u3063\u305f\u3053\u3068\u304c\u52c9\u5f37\u3078\u306e\u5fc3\u7406\u7684\u30cf\u30fc\u30c9\u30eb\u3092\u4e0b\u3052\u305f\u306e\u3067\u306f\u306a\u3044\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u8ab2\u984c\u3092\u89e3\u304d\u3001\u305d\u306e\u56de\u7b54\u3092\u9001\u308a\u8fd4\u3059\u3053\u3068\u3067\u63a1\u70b9\u3092\u3057\u3063\u304b\u308a\u3068\u3057\u3066\u3082\u3089\u3048\u307e\u3057\u305f\u3002<\/p>\n<p>\u696d\u52d9\u6642\u9593\u306b\u899a\u3048\u305f\u3053\u3068\u306e\u518d\u78ba\u8a8d\u306e\u610f\u5473\u3092\u8fbc\u3081\u3066\u554f\u984c\u306b\u53d6\u308a\u7d44\u307f\u3001\u63a1\u70b9\u3092\u3057\u3066\u3082\u3089\u3046\u3053\u3068\u3092\u7e70\u308a\u8fd4\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u63a1\u70b9\u304b\u3089\u623b\u3063\u3066\u304d\u305f\u3082\u306e\u3092\u518d\u5ea6\u52c9\u5f37\u3059\u308b\u3053\u3068\u3067\u3001\u77e5\u8b58\u306e\u30d9\u30fc\u30b9\u304c\u79c1\u306e\u8133\u5185\u306b\u51fa\u6765\u305f\u306e\u3060\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<h3><span id=\"i-4\">\u6163\u308c\u306a\u3044\u5185\u5bb9\u306f\u6642\u9593\u304c\u639b\u304b\u3063\u305f<\/span><\/h3>\n<p>\u666e\u6bb5\u306e\u696d\u52d9\u3067\u4f7f\u308f\u306a\u3044\u6280\u8853\u306b\u95a2\u3057\u3066\u306f\u3001\u304b\u306a\u308a\u306e\u6642\u9593\u304c\u639b\u304b\u308a\u307e\u3057\u305f\u306d\u3002<\/p>\n<p>\u307e\u305f\u305d\u3046\u3044\u3046\u7ae0\u306f\u7dca\u6025\u6027\u3082\u4f4e\u304b\u3063\u305f\u306e\u3067\u3001\u554f\u984c\u3084\u30c6\u30ad\u30b9\u30c8\u3082\u5f8c\u56de\u3057\u306b\u3057\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2><span id=\"i-5\">\u307e\u3068\u3081<\/span><\/h2>\n<p><img class=\"aligncenter size-full wp-image-2098\" src=\"https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2019\/06\/154da6d191229eb190b9a35a0a27e4fc_s.jpg\" alt=\"\" width=\"640\" height=\"427\" srcset=\"https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2019\/06\/154da6d191229eb190b9a35a0a27e4fc_s.jpg 640w, https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2019\/06\/154da6d191229eb190b9a35a0a27e4fc_s-300x200.jpg 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>\u6559\u6750\u3092\u5b8c\u4e86\u5f8c\u3001\u6700\u5f8c\u306b\u5408\u683c\u901a\u77e5\u3068\u534a\u984d\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u30d0\u30c3\u30af\u3092\u8cb0\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n<p>\u305f\u3060\u3001\u4eca\u306e\u6642\u4ee3\u306f\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u3092\u5b66\u3076\u306b\u3057\u3066\u3082<span class=\"huto\">\u5168\u90e8\u30aa\u30f3\u30e9\u30a4\u30f3<\/span>\u3067\u3067\u304d\u3066\u3057\u307e\u3046\u3093\u3067\u3059\u3088\u306d\u3002<\/p>\n<p>\u8cea\u554f\u304c\u3042\u308b\u6642\u306a\u3069\u3082\u30c1\u30e3\u30c3\u30c8\u3067\u3059\u3050\u306b\u56de\u7b54\u304c\u3082\u3089\u3048\u308b\u306e\u306f\u3059\u3054\u3044\u306a\u3068\u601d\u3044\u307e\u3057\u305f\u3002<\/p>\n\t\t\t<a href=\"https:\/\/thirtiesprogrammer.com\/?p=1233\" class=\"st-cardlink\">\n\t\t\t<div class=\"kanren st-cardbox\" >\n\t\t\t\t\t\t\t\t<dl class=\"clearfix\">\n\t\t\t\t\t<dt class=\"st-card-img\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img width=\"150\" height=\"150\" src=\"https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2018\/11\/0829_3-150x150.jpg\" class=\"attachment-st_thumb150 size-st_thumb150 wp-post-image\" alt=\"30\u4ee3\u3067\u30c6\u30c3\u30af\u30a2\u30ab\u30c7\u30df\u30fc\u306b\u5165\u3063\u3066\u8ee2\u8077\u3067\u304d\u308b\u306e\u304b\uff1f\" loading=\"lazy\" srcset=\"https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2018\/11\/0829_3-150x150.jpg 150w, https:\/\/thirtiesprogrammer.com\/wp\/wp-content\/uploads\/2018\/11\/0829_3-100x100.jpg 100w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t<\/dt>\n\t\t\t\t\t<dd>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<h5 class=\"st-cardbox-t\">30\u4ee3\u3067\u30c6\u30c3\u30af\u30a2\u30ab\u30c7\u30df\u30fc\u306b\u5165\u3063\u3066\u8ee2\u8077\u3059\u308b\u65b9\u6cd5<\/h5>\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"st-card-excerpt smanone\">\n\t\t\t\t\t\t\t\t<p>\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u30b9\u30af\u30fc\u30eb\u8b1b\u5e2b\u306e\u6589\u85e4\u3067\u3059\u3002 \u30c6\u30c3\u30af\u30a2\u30ab\u30c7\u30df\u30fc\u306f30\u4ee3\u3067\u3082\u53d7\u3051\u5165\u308c\u3066\u304f\u308c\u308b\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u30b9\u30af\u30fc\u30eb\u3067\u3059\u3002 \u3053\u3053\u3067\u306f\u300130\u4ee3\u3067\u30c6\u30c3\u30af\u30a2\u30ab\u30c7\u30df\u30fc\u306b\u5165\u3063\u3066\u8ee2\u8077\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002 \u76ee\u6b21 &#8230; <\/p>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<p class=\"cardbox-more\">\u7d9a\u304d\u3092\u898b\u308b<\/p>\n\t\t\t\t\t\t\t\t\t\t\t<\/dd>\n\t\t\t\t<\/dl>\n\t\t\t<\/div>\n\t\t\t<\/a>\n\t\t\t\n","protected":false},"excerpt":{"rendered":"<p>\u79c1\u304cExcelVBA\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u3092\u5b66\u307c\u3046\u3068\u3057\u305f\u969b\u3001\u307e\u305a\u306f\u5927\u624b\u4f01\u696d\u304c\u884c\u3063\u3066\u3044\u308b\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u306e\u901a\u4fe1\u6559\u80b2\u3092\u53d7\u3051\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002 \u305f\u307e\u305f\u307e\u30ad\u30e3\u30f3\u30da\u30fc\u30f3\u4e2d\u3067\u534a\u984d\u30ad\u30e3\u30c3\u30b7\u30e5\u30d0\u30c3\u30af\u4ed8\u304d\u3060\u3063\u305f\u3068\u3044\u3046\u306e\u3082\u7406\u7531\u306e\u3072 &#8230; <\/p>\n","protected":false},"author":1,"featured_media":2449,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[67,80],"tags":[],"_links":{"self":[{"href":"https:\/\/thirtiesprogrammer.com\/index.php?rest_route=\/wp\/v2\/posts\/2435"}],"collection":[{"href":"https:\/\/thirtiesprogrammer.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thirtiesprogrammer.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thirtiesprogrammer.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thirtiesprogrammer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2435"}],"version-history":[{"count":6,"href":"https:\/\/thirtiesprogrammer.com\/index.php?rest_route=\/wp\/v2\/posts\/2435\/revisions"}],"predecessor-version":[{"id":2453,"href":"https:\/\/thirtiesprogrammer.com\/index.php?rest_route=\/wp\/v2\/posts\/2435\/revisions\/2453"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thirtiesprogrammer.com\/index.php?rest_route=\/wp\/v2\/media\/2449"}],"wp:attachment":[{"href":"https:\/\/thirtiesprogrammer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thirtiesprogrammer.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thirtiesprogrammer.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}