{"id":172,"date":"2023-01-30T14:39:39","date_gmt":"2023-01-30T05:39:39","guid":{"rendered":"http:\/\/www.vba.dai-toku.com\/?p=172"},"modified":"2023-01-30T14:46:05","modified_gmt":"2023-01-30T05:46:05","slug":"%e5%a4%89%e6%95%b0%ef%bc%91%ef%bc%90%ef%bc%88%e3%83%96%e3%83%83%e3%82%af%e3%80%81%e3%82%b7%e3%83%bc%e3%83%88%e3%81%ae%e6%93%8d%e4%bd%9c%ef%bc%9a%e7%95%b0%e3%83%96%e3%83%83%e3%82%af%e9%96%93%e3%80%80","status":"publish","type":"post","link":"https:\/\/www.vba.dai-toku.com\/?p=172","title":{"rendered":"\u5909\u6570\uff11\uff10\uff08\u30d6\u30c3\u30af\u3001\u30b7\u30fc\u30c8\u306e\u64cd\u4f5c\uff1a\u7570\u30d6\u30c3\u30af\u9593\u3000\u30b7\u30fc\u30c8\u9593\u3000\u5024\u5909\u66f4\u51e6\u7406\uff09"},"content":{"rendered":"\n

\u30b5\u30f3\u30d7\u30eb\u30d5\u30a1\u30a4\u30eb<\/a>\u306f\u3053\u3061\u3089


Book1 \u306e A \u30b7\u30fc\u30c8\u306eC2\u30bb\u30eb\u306e\u5024\u3092
Book2 \u306e A \u30b7\u30fc\u30c8\u306eB7\u30bb\u30eb\u306b\uff13\u500d\u3057\u3066\u8868\u793a\u3055\u305b\u308b

\u3068\u3044\u3046\u4f8b\u3092\u8003\u3048\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n

<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

\u7570\u30d6\u30c3\u30af\u9593\u3067\u30c7\u30fc\u30bf\u3092\u3084\u308a\u3068\u308a\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u306a\u3082\u306e\u306f

\u5c11\u306a\u304f\u3068\u3082\uff12\u3064\u306e\u30d6\u30c3\u30af\u3000\u3068\u3000\uff12\u3064\u306e\u30b7\u30fc\u30c8<\/mark><\/strong>\u3067\u3059\u3002

\u3082\u3063\u3068\u8a00\u3046\u3068
\u5143\u30d6\u30c3\u30af\u3068\u305d\u306e\u5143\u30d6\u30c3\u30af\u306b\u542b\u307e\u308c\u308b\u5143\u30b7\u30fc\u30c8\u3000\u3068
\u5148\u30d6\u30c3\u30af\u3068\u305d\u306e\u5148\u30d6\u30c3\u30af\u306b\u542b\u307e\u308c\u308b\u5148\u30b7\u30fc\u30c8\u3000\u304c\u5fc5\u8981\u3067\u3059\u3002


\u3067\u3059\u306e\u3067\u3001\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u30fc\u3092\u6e96\u5099\u3059\u308b\u3068\u3068\u3082\u306b\u3000\u5373\u5ea7\u306b
<\/p>\n\n\n\n

Dim wb_1 As Workbook\nDim wb_2 As Workbook\nDim ws1_a As Worksheet\nDim ws2_a As Worksheet<\/mark><\/strong>\nDim c2 As Integer\n\nSet wb_1 = Workbooks(\"Book1.xlsm\")\nSet wb_2 = Workbooks(\"Book2.xlsm\")\nSet ws1_a = wb_1.Worksheets(\"A\")\nSet ws2_a = wb_2.Worksheets(\"A\")<\/mark><\/strong><\/code><\/pre>\n\n\n\n

\u3068 \u5ba3\u8a00 \u3068 Set \u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
<\/div>\n\n\n\n
\u5ba3\u8a00\u304c\u7d42\u308f\u308c\u3070\u3042\u3068\u306f\u7c21\u5358\u3067\u3059\u3002
\u307e\u305a\u306f\u5143\u3068\u306a\u308b\u30bb\u30eb\u306e\u5024\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002\u305d\u308c\u306f\u524d\u56de\u306e\u8a18\u4e8b\u3067\u6271\u3063\u305f\u3088\u3046\u306b
c2<\/mark><\/strong> = ws1_a.Range(“c2”)<\/mark><\/strong>\u3000\u3068\u547d\u4ee4\u3059\u308c\u3070 \u5909\u6570c2\u306b\u4ee3\u5165\u3057\u3066\u4f7f\u3044\u307e\u308f\u305b\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002

\u305d\u3057\u3066\u3001\u305d\u306e\u79fb\u52d5\u5148\u306b\u5bfe\u3057\u3066\u306f
ws2_a.Range(“a7”)<\/mark><\/strong> =<\/strong> c2 * 7\u3000\u3068\u547d\u4ee4\u3059\u308b\u3053\u3068\u3067\u7279\u5b9a\u3067\u304d\u3001\u4ee3\u5165\u3067\u304d\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u30b5\u30f3\u30d7\u30eb\u30d5\u30a1\u30a4\u30eb\u306f\u3053\u3061\u3089 Book1 \u306e A \u30b7\u30fc\u30c8\u306eC2\u30bb\u30eb\u306e\u5024\u3092Book2 \u306e A \u30b7\u30fc\u30c8\u306eB7\u30bb\u30eb\u306b\uff13\u500d\u3057\u3066\u8868\u793a\u3055\u305b\u308b \u3068\u3044\u3046\u4f8b\u3092\u8003\u3048\u307e\u3057\u3087\u3046\u3002 \u7570\u30d6\u30c3\u30af\u9593\u3067\u30c7\u30fc\u30bf\u3092\u3084\u308a\u3068\u308a\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u306a\u3082\u306e\u306f \u5c11\u306a\u304f\u3068\u3082\uff12\u3064\u306e […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-172","post","type-post","status-publish","format-standard","hentry","category-basic"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.vba.dai-toku.com\/index.php?rest_route=\/wp\/v2\/posts\/172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vba.dai-toku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vba.dai-toku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vba.dai-toku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vba.dai-toku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=172"}],"version-history":[{"count":2,"href":"https:\/\/www.vba.dai-toku.com\/index.php?rest_route=\/wp\/v2\/posts\/172\/revisions"}],"predecessor-version":[{"id":177,"href":"https:\/\/www.vba.dai-toku.com\/index.php?rest_route=\/wp\/v2\/posts\/172\/revisions\/177"}],"wp:attachment":[{"href":"https:\/\/www.vba.dai-toku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vba.dai-toku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vba.dai-toku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}