{"provider_name":"Hatena Blog","height":"190","type":"rich","author_url":"https://blog.hatena.ne.jp/Infoment/","author_name":"Infoment","published":"2019-03-13 22:30:27","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Finfoment.hatenablog.com%2Fentry%2F2019%2F03%2F13%2F223027\" title=\"\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u3067\u3001\u300c\u5e74\u6708\u9031\u3067\u30b0\u30eb\u30fc\u30d7\u5316\u300d\u3063\u307d\u3044\u3053\u3068\u3092\u3057\u3066\u307f\u308b - Infoment\u306e\u30d6\u30ed\u30b0 \uff5eExcel VBA\u596e\u95d8\u8a18\uff5e\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","width":"100%","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/I/Infoment/20190313/20190313220909.png","categories":["Excel","VBA","\u4f5c\u3063\u3066\u307f\u305f"],"url":"https://infoment.hatenablog.com/entry/2019/03/13/223027","provider_url":"https://hatena.blog","version":"1.0","blog_title":"Infoment\u306e\u30d6\u30ed\u30b0 \uff5eExcel VBA\u596e\u95d8\u8a18\uff5e","blog_url":"https://infoment.hatenablog.com/","title":"\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u3067\u3001\u300c\u5e74\u6708\u9031\u3067\u30b0\u30eb\u30fc\u30d7\u5316\u300d\u3063\u307d\u3044\u3053\u3068\u3092\u3057\u3066\u307f\u308b","description":"\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u3067\u3001\u90e8\u54c1\u306e\u5165\u51fa\u5eab\u5c65\u6b74\u3092\u4f5c\u6210\u3057\u305f\u6642\u306e\u3053\u3068\u3002\u6708\u5358\u4f4d\u3067\u306e\u96c6\u8a08\u306b\u5bfe\u3057\u3001\u300c\u9031\u5358\u4f4d\u3067\u898b\u305f\u3044\u300d\u3068\u3044\u3046\u8981\u671b\u3092\u3044\u305f\u3060\u3044\u305f\u306e\u3067\u6311\u6226\u3057\u3066\u307f\u305f\u3002 \u307e\u305a\u4eca\u56de\u306e\u8a18\u4e8b\u7528\u306b\u3001\u30c0\u30df\u30fc\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3059\u308b\u3002\u304b\u306a\u308a\u30ca\u30de\u30af\u30e9\u3057\u3066\u4f5c\u3063\u305f\u30c7\u30fc\u30bf\u304c\u3053\u3061\u3089\u3002 Sub \u30c7\u30fc\u30bf\u4f5c\u6210() Dim seq(1 To 1000, 1 To 3) Dim goods As Variant goods = Array(\"\u308a\u3093\u3054\", \"\u307f\u304b\u3093\", \"\u30d0\u30ca\u30ca\") Dim i As Long Dim goodsIndex As Long Dim goodsCount As Long seq(1, 1) = \"\u5546\u54c1\u540d\" seq(1, 2) = \"\u65e5\u4ed8\u2026"}