{"height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fken3code.hatenablog.jp%2Fentry%2F2021%2F02%2F28%2F190000\" title=\"Excel VBA UsedRange \u3067\u4f7f\u7528\u7bc4\u56f2\u3092\u53d6\u5f97 - \u4e09\u6d41\u541b\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u7f6e\u304d\u5834\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://ken3code.hatenablog.jp/entry/2021/02/28/190000","blog_url":"https://ken3code.hatenablog.jp/","provider_name":"Hatena Blog","width":"100%","author_name":"ken3memo","type":"rich","blog_title":"\u4e09\u6d41\u541b\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u7f6e\u304d\u5834","image_url":null,"version":"1.0","description":"Excel VBA UsedRange \u3067\u4f7f\u7528\u7bc4\u56f2\u3092\u53d6\u5f97\u3057\u3066 Rows.Count \u3067\u884c\u6570 \u6700\u7d42\u884c\u306f Cells(objRANGE.Rows.Count, 1).Row \u306a\u3093\u3066\u611f\u3058\u3067\u9060\u56de\u308a\u3067\u53d6\u5f97\u3057\u3066\u307f\u305fDim objRANGE As Range Set objRANGE = ActiveSheet.UsedRange '\u30bb\u30eb\u306e\u4f7f\u7528\u7bc4\u56f2\u3092\u53d6\u5f97VBA Excel \u8868 \u7bc4\u56f2 \u3067\u691c\u7d22\u3059\u308b\u3068 \u4e0b\u8a18\u306e\u308f\u304b\u308a\u3084\u3059\u3044\u30da\u30fc\u30b8\u304c\u30d2\u30c3\u30c8\u3057\u307e\u3059\u30bb\u30eb\u7bc4\u56f2\u306e\u53d6\u5f97 \u30bb\u30eb\u7bc4\u56f2\u306e\u53d6\u5f97 http://officetanaka.net/excel/vba/cell/cell10.htm \u3088\u308a \uff1e \uff1e\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u3067\u4f7f\u7528\u3055\u308c\u3066\u3044\u308b\u30bb\u30eb\u2026","provider_url":"https://hatena.blog","categories":[],"author_url":"https://blog.hatena.ne.jp/ken3memo/","published":"2021-02-28 19:00:00","title":"Excel VBA UsedRange \u3067\u4f7f\u7528\u7bc4\u56f2\u3092\u53d6\u5f97"}