{"id":139,"date":"2016-09-29T05:20:00","date_gmt":"2016-09-28T20:20:00","guid":{"rendered":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/2015\/10\/23\/vba-%e3%81%a1%e3%82%87%e3%81%a3%e3%81%a8%e8%a3%8f%e6%8a%80%e3%80%82redim%e3%82%92%e4%bd%bf%e3%81%a3%e3%81%a6%e5%8f%af%e5%a4%89%e9%85%8d%e5%88%97%e3%81%ab\/"},"modified":"2016-09-29T05:30:32","modified_gmt":"2016-09-28T20:30:32","slug":"vba-redim-array","status":"publish","type":"post","link":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/2016\/09\/29\/vba-redim-array\/","title":{"rendered":"Excel\/VBA\u3067\u3061\u3087\u3063\u3068\u88cf\u6280 ReDim\u3092\u4f7f\u3063\u3066\u53ef\u5909\u914d\u5217\u306b\u3059\u308b"},"content":{"rendered":"<p style=\"text-align: center;\">[ad#top-1]<\/p>\n<p>\u914d\u5217\u3092\u4f7f\u3046\u969b\u306b\u521d\u671f\u306e\u6bb5\u968e\u3067\u3069\u3046\u3057\u3066\u3082\u8981\u7d20\u6570\u304c\u6c7a\u5b9a\u3057\u306a\u3044\u5834\u5408\u3001ReDim\u3067\u5f8c\u3067\u67a0\u3092\u5e83\u3052\u308b\u65b9\u6cd5\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u4ee5\u524d\u7d39\u4ecb\u3057\u305f<a href=\"http:\/\/non-it-salaryman.blogspot.jp\/2015\/05\/vba_17.html\" target=\"_blank\">\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u4f7f\u3046\u65b9\u6cd5<\/a>\u3082\u3042\u308b\u306e\u3067\u3059\u304c\u3001\u5358\u7d14\u306a\u914d\u5217\u3092\u4f7f\u3044\u305f\u3044\u5834\u5408\u306f\u3053\u3061\u3089\u306e\u65b9\u304c\u4f7f\u3044\u52dd\u624b\u304c\u3044\u3044\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n<p>\u3053\u3061\u3089\u304c\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3067\u3059\u3002<\/p>\n<p><script src=\"https:\/\/gist.github.com\/satoshi71\/1a8c65d6d2bb4dcebc5c04481ed665cd.js\"><\/script><\/p>\n<p>\u3053\u308c\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u304c\u73fe\u308c\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2442\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2015\/10\/1.png\" alt=\"1\" width=\"189\" height=\"148\" \/><\/p>\n<p>\u4ee5\u4e0b\u3001\u89e3\u8aac\u3067\u3059\u3002<\/p>\n<p>\u307e\u305a\u6700\u521d\u306b\u8981\u7d20\u6570\u3092\u6307\u5b9a\u305b\u305a\u306b\u914d\u5217\u5ba3\u8a00\u3057\u307e\u3059\u3002<br \/>\n<code data-gist-id=\"1a8c65d6d2bb4dcebc5c04481ed665cd\" data-gist-line=\"2-4\"><\/code><br \/>\n\u6b21\u306b\u914d\u5217\u306b\u6570\u5024\u3092\u4ee3\u5165\u3057\u307e\u3059\u304c\u3001\u8981\u7d20\u3092\u5165\u308c\u308b\u524d\u306b<span style=\"color: #0000ff;\">ReDim Preserve<\/span>\u3092\u4f7f\u3063\u3066\u914d\u5217\u3092\u5ba3\u8a00\u3057\u76f4\u3057\u307e\u3059\u3002\u3053\u3053\u304c\u30dd\u30a4\u30f3\u30c8\u3067\u3059\u3002<br \/>\n<code data-gist-id=\"1a8c65d6d2bb4dcebc5c04481ed665cd\" data-gist-line=\"4-9\"><\/code><\/p>\n<p>&nbsp;<\/p>\n<p>\u6700\u5f8c\u306b\u914d\u5217\u306e\u5404\u8981\u7d20\u3092\u9023\u7d50\u3057\u3066\u6587\u5b57\u5217\u5316\u3057\u3066\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u3067\u8868\u793a\u3055\u305b\u307e\u3057\u305f\u3002<br \/>\n<code data-gist-id=\"1a8c65d6d2bb4dcebc5c04481ed665cd\" data-gist-line=\"9-16\"><\/code><\/p>\n<p>&nbsp;<\/p>\n<p><script type=\"text\/javascript\" src=\"http:\/\/pineplanter.moo.jp\/lib\/gist-embed.min.js\"><\/script><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\">[ad#ad-1]<\/p>\n<p><script src=\"http:\/\/ws-fe.amazon-adsystem.com\/widgets\/q?rt=tf_mfw&amp;ServiceVersion=20070822&amp;MarketPlace=JP&amp;ID=V20070822%2FJP%2Fsuwebstore-22%2F8001%2F6c7b89f4-af38-48a2-8787-e45d7431be11\" type=\"text\/javascript\" charset=\"utf-8\">\/\/ <![CDATA[\n \n\/\/ ]]><\/script><noscript><A rel=\"nofollow\" HREF=\"http:\/\/ws-fe.amazon-adsystem.com\/widgets\/q?rt=tf_mfw&#038;ServiceVersion=20070822&#038;MarketPlace=JP&#038;ID=V20070822%2FJP%2Fsuwebstore-22%2F8001%2F6c7b89f4-af38-48a2-8787-e45d7431be11&#038;Operation=NoScript\">Amazon.co.jp \u30a6\u30a3\u30b8\u30a7\u30c3\u30c8<\/A><\/noscript><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad#top-1] \u914d\u5217\u3092\u4f7f\u3046\u969b\u306b\u521d\u671f\u306e\u6bb5\u968e\u3067\u3069\u3046\u3057\u3066\u3082\u8981\u7d20\u6570\u304c\u6c7a\u5b9a\u3057\u306a\u3044\u5834\u5408 &#8230; <\/p>\n","protected":false},"author":1,"featured_media":2447,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,6],"tags":[],"class_list":["post-139","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-vba"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/posts\/139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/comments?post=139"}],"version-history":[{"count":6,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/posts\/139\/revisions"}],"predecessor-version":[{"id":2445,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/posts\/139\/revisions\/2445"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/media\/2447"}],"wp:attachment":[{"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/media?parent=139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/categories?post=139"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/tags?post=139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}