{"id":274,"date":"2023-08-05T09:25:27","date_gmt":"2023-08-05T00:25:27","guid":{"rendered":"https:\/\/rafa-system.com\/vba\/?p=274"},"modified":"2023-08-05T09:25:46","modified_gmt":"2023-08-05T00:25:46","slug":"post-274","status":"publish","type":"post","link":"https:\/\/rafa-system.com\/vba\/2023\/08\/05\/post-274\/","title":{"rendered":"\u51e6\u7406\u306e\u4e2d\u3067\u4e00\u77ac\u3060\u3051\u88dc\u52a9\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u3092\u4f5c\u3063\u3066\u7834\u68c4\u3059\u308b"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u305f\u3068\u3048\u3070\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u306eUnique()\u3092\u4f7f\u3044\u305f\u3044\u6642<\/p>\n\n\n\n<pre class=\"wp-block-luxe-blocks-syntaxhighlighter line-numbers language-vba\"><code class=\"language-vba\">Sub testin()\n    Dim arr: arr = Array(\"a\", \"a\", \"b\", \"b\", \"c\")\n    With Sheets.Add\n        .Range(\"A1\").Resize(UBound(arr) + 1) = WorksheetFunction.Transpose(arr)\n        arr = WorksheetFunction.Unique(.Range(\"A1\").CurrentRegion)\n        Application.DisplayAlerts = False\n        .Delete\n        Application.DisplayAlerts = True\n    End With\nEnd Sub<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"252\" height=\"203\" src=\"https:\/\/rafa-system.com\/vba\/wp-content\/uploads\/2023\/08\/image-1.png\" alt=\"\" class=\"wp-image-275\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e8c\u6b21\u5143\u914d\u5217\u306b\u306a\u3063\u3061\u3083\u3046\u70b9\u3060\u3051\u6ce8\u610f<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u305f\u3068\u3048\u3070\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u306eUnique()\u3092\u4f7f\u3044\u305f\u3044\u6642 \u4e8c\u6b21\u5143\u914d\u5217\u306b\u306a\u3063\u3061\u3083\u3046\u70b9\u3060\u3051\u6ce8\u610f<\/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-274","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\/274","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=274"}],"version-history":[{"count":2,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/posts\/274\/revisions"}],"predecessor-version":[{"id":277,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/posts\/274\/revisions\/277"}],"wp:attachment":[{"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/media?parent=274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/categories?post=274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rafa-system.com\/vba\/wp-json\/wp\/v2\/tags?post=274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}