{"categories":["Excel","VBA","\u5931\u6557\u8ac7"],"height":"190","type":"rich","author_url":"https://blog.hatena.ne.jp/Infoment/","blog_url":"https://infoment.hatenablog.com/","published":"2021-02-22 23:37:00","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","width":"100%","description":"\u4ee5\u524d\u3001\u5931\u6557\u8ac7\u3068\u3057\u3066\u3053\u3093\u306a\u8a71\u3092\u66f8\u3044\u305f\u3002 Transpose\u95a2\u6570\u306b\u306f\u3001\u884c\u5217\u5165\u308c\u66ff\u3048\u306e\u4e0a\u9650\u304c\u3042\u308b\u3089\u3057\u3044\u3001\u3068\u3044\u3046\u8a71\u3060\u3002 infoment.hatenablog.com\u3068\u3053\u308d\u304c\u3088\u304f\u3088\u304f\u8abf\u3079\u3066\u307f\u308b\u3068\u3001\u5931\u6557\u8ac7\u3068\u3057\u3066\u7d39\u4ecb\u3057\u305f\u304b\u3063\u305f\u5185\u5bb9\u3092\u3001 \u6b63\u3057\u304f\u518d\u73fe\u3067\u304d\u3066\u3044\u306a\u3044\u3053\u3068\u306b\u6c17\u3065\u3044\u305f\uff08\u5076\u7136\uff09\u3002\u5f53\u6642\u63b2\u8f09\u3057\u305f\u30b3\u30fc\u30c9\u304c\u3053\u3061\u3089\u3002 Sub Test() Dim arr(1, 1) As Variant Dim i As Long Dim temp As Variant On Error Resume Next Do i = i + 1 arr(0, 0) = WorksheetFunction.Rept(\"\u3042\", i) tem\u2026","image_url":"https://cdn.blog.st-hatena.com/images/theme/og-image-1500.png","author_name":"Infoment","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Finfoment.hatenablog.com%2Fentry%2F2021%2F02%2F22%2F233700\" title=\"\u5931\u6557\u8ac7\u306e\u5931\u6557\u518d\u73fe\u3092\u5931\u6557\u3057\u3066\u3044\u305f\u8a71\uff08\u5931\u6557\u8ac7\uff09 - 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>","blog_title":"Infoment\u306e\u30d6\u30ed\u30b0 \uff5eExcel VBA\u596e\u95d8\u8a18\uff5e","title":"\u5931\u6557\u8ac7\u306e\u5931\u6557\u518d\u73fe\u3092\u5931\u6557\u3057\u3066\u3044\u305f\u8a71\uff08\u5931\u6557\u8ac7\uff09","version":"1.0","url":"https://infoment.hatenablog.com/entry/2021/02/22/233700"}