{"id":96,"date":"2023-07-19T20:43:57","date_gmt":"2023-07-19T11:43:57","guid":{"rendered":"https:\/\/rafa-system.com\/vba\/?p=96"},"modified":"2023-07-19T20:43:57","modified_gmt":"2023-07-19T11:43:57","slug":"post-96","status":"publish","type":"post","link":"https:\/\/rafa-system.com\/vba\/2023\/07\/19\/post-96\/","title":{"rendered":"\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u3092\u30b3\u30d4\u30fc\u3057\u3066\u51e6\u7406\u3059\u308b"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u5143\u30c7\u30fc\u30bf\u3092\u4fdd\u8b77\u3057\u305f\u307e\u307e\u51e6\u7406\u3057\u305f\u3044\u6642\u306b\u4f7f\u3048\u308b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Sub CopySheetAndProcess()\r\n    Dim newWs As Worksheet\r\n    Sheet16.Copy After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count) ' \u30b7\u30fc\u30c8\u3092\u30b3\u30d4\u30fc\r\n    Set newWs = ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count) ' \u30b3\u30d4\u30fc\u3057\u305f\u65b0\u3057\u3044\u30b7\u30fc\u30c8\u3092\u53d6\u5f97\r\n    \r\n    ' newWs\u3078\u306e\u51e6\u7406\u3044\u308d\u3044\u308d\uff08\u4f8b\uff1a\u30c7\u30fc\u30bf\u306e\u66f8\u304d\u8fbc\u307f\u3001\u30d5\u30a3\u30eb\u30bf\u30fc\u3084\u30bd\u30fc\u30c8\u306e\u8a2d\u5b9a\u306a\u3069\uff09\r\n    newWs.Range(\"A1\").Value = \"Hello, this is a copied sheet!\"\r\n    \r\n    ' \u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u3092\u524a\u9664\uff08\u65b0\u3057\u3044\u30b7\u30fc\u30c8\u3092\u524a\u9664\u3059\u308b\u3053\u3068\u3067\u30b3\u30d4\u30fc\u5143\u306e\u30b7\u30fc\u30c8\u3060\u3051\u304c\u6b8b\u308a\u307e\u3059\uff09\r\n    Application.DisplayAlerts = False ' \u524a\u9664\u6642\u306e\u8b66\u544a\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u975e\u8868\u793a\u306b\u3059\u308b\r\n    newWs.Delete\r\n    Application.DisplayAlerts = True\r\nEnd Sub<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5143\u30c7\u30fc\u30bf\u3092\u4fdd\u8b77\u3057\u305f\u307e\u307e\u51e6\u7406\u3057\u305f\u3044\u6642\u306b\u4f7f\u3048\u308b<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[12],"class_list":["post-96","post","type-post","status-publish","format-standard","hentry","category-11","tag-12"],"_links":{"self":[{"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/posts\/96","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/comments?post=96"}],"version-history":[{"count":1,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/posts\/96\/revisions"}],"predecessor-version":[{"id":97,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/posts\/96\/revisions\/97"}],"wp:attachment":[{"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/media?parent=96"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/categories?post=96"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/tags?post=96"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}