{"published":"2025-09-18 00:32:11","width":"100%","categories":["VBA\u306e\u843d\u3068\u3057\u7a74","\u914d\u5217(Array)","\u30b7\u30fc\u30c8\u95a2\u6570\u30fbVBA\u95a2\u6570","VBA"],"author_name":"LimeCode","url":"https://www.limecode.jp/entry/trap/worksheetfunction-cut-1d-array-over-65536","type":"rich","description":"WorksheetFunction(\u4ee5\u4e0bWF)\u306b\u6e21\u305b\u308b\u4e00\u6b21\u5143\u914d\u5217\u306b\u306f\u4e0a\u9650\u304c\u3042\u308a\u300165,537\u3092\u8d85\u3048\u308b\u4ef6\u6570\u306e\u4e00\u6b21\u5143\u914d\u5217\u3092\u6b63\u3057\u304f\u53d7\u3051\u53d6\u308c\u307e\u305b\u3093\u3002\u4e8c\u6b21\u5143\u914d\u5217\u3084Range\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6e21\u305b\u3070\u6b63\u3057\u304f\u52d5\u304f\u306e\u3067\u4e00\u6b21\u5143\u914d\u5217\u306e\u307f\u304a\u6c17\u3092\u4ed8\u3051\u304f\u3060\u3055\u3044\u3002","title":"WorksheetFunction\u306b\u4e00\u6b21\u5143\u914d\u5217\u3092\u6e21\u3059\u3068\u914d\u5217\u304c\u6b20\u640d\u3059\u308b","provider_url":"https://hatena.blog","version":"1.0","author_url":"https://blog.hatena.ne.jp/LimeCode/","blog_title":"\u548c\u98a8\u30b9\u30d1\u30b2\u30c6\u30a3\u306e\u30ec\u30b7\u30d4","blog_url":"https://www.limecode.jp/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.limecode.jp%2Fentry%2Ftrap%2Fworksheetfunction-cut-1d-array-over-65536\" title=\"WorksheetFunction\u306b\u4e00\u6b21\u5143\u914d\u5217\u3092\u6e21\u3059\u3068\u914d\u5217\u304c\u6b20\u640d\u3059\u308b - \u548c\u98a8\u30b9\u30d1\u30b2\u30c6\u30a3\u306e\u30ec\u30b7\u30d4\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190","image_url":"https://cdn.user.blog.st-hatena.com/default_entry_og_image/154743825/1575205807164226","provider_name":"Hatena Blog"}