{"provider_url":"https://hatena.blog","published":"2020-01-03 20:15:00","author_name":"ExcelLover","categories":["\u914d\u5217"],"url":"https://www.excellovers.com/entry/dynamicarray01","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.excellovers.com%2Fentry%2Fdynamicarray01\" title=\"\u4e00\u98a8\u5909\u308f\u3063\u305f\uff1f\u52d5\u7684\u914d\u5217\u306e\u5ba3\u8a00\u65b9\u6cd5 - Excel\u304c\u5927\u597d\u304d\u3060\uff01\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_url":"https://www.excellovers.com/","provider_name":"Hatena Blog","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/E/ExcelLover/20200103/20200103195539.jpg","height":"190","title":"\u4e00\u98a8\u5909\u308f\u3063\u305f\uff1f\u52d5\u7684\u914d\u5217\u306e\u5ba3\u8a00\u65b9\u6cd5","type":"rich","blog_title":"Excel\u304c\u5927\u597d\u304d\u3060\uff01","version":"1.0","author_url":"https://blog.hatena.ne.jp/ExcelLover/","description":"\u52d5\u7684\u914d\u5217\u3092\u5ba3\u8a00\u3059\u308b\u6642\u306f\u3069\u3046\u3057\u3066\u3044\u307e\u3059\u304b\uff1f Dim Var() as variant Redim Var(1 to 3) \u4e0a\u8a18\u306e\u3088\u3046\u306b\u5909\u6570\u540d\u306e\u5f8c\u306b\uff08\uff09\u3092\u3064\u3051\u3066\u5ba3\u8a00\u3057\u3001 Redim\u3067\u8981\u7d20\u6570\u3092\u6307\u5b9a\u3057\u3066\u304b\u3089\u4f7f\u7528\u3059\u308b\u306e\u3067\u306f\u306a\u3044\u3067\u3057\u3087\u3046\u304b\u3002 \u3057\u304b\u3057\u4eca\u56de\u9577\u5e74\u898b\u6163\u308c\u305f\u3053\u306e\u65b9\u6cd5\u3068\u306f\u9055\u3046\u5ba3\u8a00\u65b9\u6cd5\u306b\u51fa\u4f1a\u3044\u307e\u3057\u305f\u3002 \uff08\uff09\u306a\u3057\u3067\u52d5\u7684\u914d\u5217\u5ba3\u8a00\uff08\u306e\u6e96\u5099\uff09 \uff08\uff09\u306a\u3057\u3067Variant\u578b\u306e\u52d5\u7684\u914d\u5217\u3092\u5ba3\u8a00\u3059\u308b\u65b9\u6cd5\u3067\u3059\u3002 Dim Var as variant \u624b\u5143\u306b\u3042\u308bExcel VBA\u306e\u672c\u3092\u8abf\u3079\u3066\u3082\uff08\uff09\u306a\u3057\u3067\u5ba3\u8a00\u3057\u3066\u3044\u308b\u3082\u306e\u306f\u3042\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002 \u81ea\u5206\u3082\u4eca\u307e\u3067\u52d5\u7684\u914d\u5217\u3092\u5ba3\u8a00\u3059\u308b\u5834\u5408\u306f\uff08\uff09\u3092\u3064\u3051\u3066\u3044\u307e\u3057\u305f\u3002 \u3067\u306f\uff08\uff09\u3092\u4ed8\u3051\u308b\u5834\u5408\u30fb\u4ed8\u3051\u2026","width":"100%"}