{"id":3982,"date":"2024-06-25T12:37:16","date_gmt":"2024-06-25T03:37:16","guid":{"rendered":"https:\/\/www.kinryo.net\/?p=3982"},"modified":"2024-06-25T12:37:16","modified_gmt":"2024-06-25T03:37:16","slug":"excel%e3%81%a7%e6%89%8b%e5%8b%95%e3%81%a7%e8%a1%8c%e3%82%92%e9%81%b8%e6%8a%9e%e3%81%97%e3%81%9f%e6%99%82%e3%81%a8%e3%83%9e%e3%82%af%e3%83%ad%e3%81%a7%e9%81%b8%e6%8a%9e%e3%81%97%e3%81%9f%e6%99%82","status":"publish","type":"post","link":"https:\/\/www.kinryo.net\/?p=3982","title":{"rendered":"EXCEL\u3067\u624b\u52d5\u3067\u884c\u3092\u9078\u629e\u3057\u305f\u6642\u3068\u30de\u30af\u30ed\u3067\u9078\u629e\u3057\u305f\u6642\u306b\u9078\u629e\u3055\u308c\u305f\u884c\u6570\u306b\u9055\u3044\u304c\u3042\u308b\uff01\uff01"},"content":{"rendered":"<p>\u4e0b\u306f\u624b\u52d5\u3067R11\u3092\u9078\u629e\u3057\u305f\u753b\u50cf<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.kinryo.net\/wp-content\/uploads\/2024\/06\/ae46b1f460ee46f789c27b264a6cb421-300x95.png\" alt=\"\" width=\"461\" height=\"146\" class=\"alignnone  wp-image-3984\" srcset=\"https:\/\/www.kinryo.net\/wp-content\/uploads\/2024\/06\/ae46b1f460ee46f789c27b264a6cb421-300x95.png 300w, https:\/\/www.kinryo.net\/wp-content\/uploads\/2024\/06\/ae46b1f460ee46f789c27b264a6cb421-1024x325.png 1024w, https:\/\/www.kinryo.net\/wp-content\/uploads\/2024\/06\/ae46b1f460ee46f789c27b264a6cb421-150x48.png 150w, https:\/\/www.kinryo.net\/wp-content\/uploads\/2024\/06\/ae46b1f460ee46f789c27b264a6cb421.png 1125w\" sizes=\"auto, (max-width: 461px) 100vw, 461px\" \/><br \/>\n\u4e0b\u306f\u30de\u30af\u30ed\u3067R11\u3092\u9078\u629e\u3057\u305f\u753b\u50cf<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.kinryo.net\/wp-content\/uploads\/2024\/06\/8089e50294910c6cb163e5cb54ad137b-300x102.png\" alt=\"\" width=\"456\" height=\"155\" class=\"alignnone  wp-image-3985\" srcset=\"https:\/\/www.kinryo.net\/wp-content\/uploads\/2024\/06\/8089e50294910c6cb163e5cb54ad137b-300x102.png 300w, https:\/\/www.kinryo.net\/wp-content\/uploads\/2024\/06\/8089e50294910c6cb163e5cb54ad137b-1024x348.png 1024w, https:\/\/www.kinryo.net\/wp-content\/uploads\/2024\/06\/8089e50294910c6cb163e5cb54ad137b-150x51.png 150w, https:\/\/www.kinryo.net\/wp-content\/uploads\/2024\/06\/8089e50294910c6cb163e5cb54ad137b.png 1131w\" sizes=\"auto, (max-width: 456px) 100vw, 456px\" \/><br \/>\n\u3053\u306e\u30de\u30af\u30ed\u306f<br \/>\nLastrow = Cells(Rows.Count, 1).End(xlUp).Row<br \/>\nFor Row1 = 11 To Lastrow Step 9<br \/>\nRows(Row1).Select<br \/>\n\u3068\u306a\u3063\u3066\u3044\u308b\u3002<br \/>\n\u306a\u3093\u3067\uff32\uff11\uff11\u3060\u3051\u3092\u9078\u3093\u3067\u3044\u308b\u306e\u306bR9\u304b\u3089R18\u8fc4\u9078\u3093\u3060\u4e8b\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u304b\uff1f<br \/>\n\u3053\u308c\u306b\u306f\u968f\u5206\u60a9\u3093\u3060\uff01\u3051\u3069\u7406\u7531\u304c\u5225\u308c\u3060\u7c21\u5358<br \/>\n<strong><span style=\"color: #ff00ff;\">\u7406\u7531\u306f\u9078\u3093\u3060\u30bb\u30eb\u306e\u4e2d\u306b\u30bb\u30eb\u7d50\u5408\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u304b\u3089\u3002<br \/>\n<\/span><\/strong><span style=\"color: #ff00ff;\"><span style=\"color: #000000;\">\u30bb\u30ebR:9 C:AF\u304b\u3089R:18 C:AF\u307e\u3067\u30bb\u30eb\u7d50\u5408\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001R11\u3092\u9078\u3093\u3067\u3082\u3053\u306e\u3088\u3046\u306bR18\u307e\u3067\u9078\u629e\u3055\u308c\u3066\u3057\u307e\u3059\u306e\u3067\u3001R11\u3060\u3051\u3092\u9078\u3076\u306b\u306f\u3001\u307e\u305a\u30bb\u30eb\u7d50\u5408\u3092\u89e3\u304b\u306a\u3044\u3068\u306a\u3089\u306a\u3044\u3002<\/span><\/span><strong><span style=\"color: #ff00ff;\"><br \/>\n<\/span><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e0b\u306f\u624b\u52d5\u3067R11\u3092\u9078\u629e\u3057\u305f\u753b\u50cf \u4e0b\u306f\u30de\u30af\u30ed\u3067R11\u3092\u9078\u629e\u3057\u305f\u753b\u50cf \u3053\u306e\u30de\u30af\u30ed\u306f Lastrow = Cells(Rows.Count, 1).End(xlUp).Row For Row1 = 11 To Lastrow  &hellip; <a href=\"https:\/\/www.kinryo.net\/?p=3982\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"vkexunit_cta_each_option":"","footnotes":""},"categories":[19],"tags":[],"class_list":["post-3982","post","type-post","status-publish","format-standard","hentry","category-19"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/posts\/3982","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3982"}],"version-history":[{"count":2,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/posts\/3982\/revisions"}],"predecessor-version":[{"id":3986,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/posts\/3982\/revisions\/3986"}],"wp:attachment":[{"href":"https:\/\/www.kinryo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3982"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3982"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3982"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}