{"author_name":"ken3memo","author_url":"https://blog.hatena.ne.jp/ken3memo/","provider_url":"https://hatena.blog","width":"100%","blog_url":"https://ken3code.hatenablog.jp/","categories":[],"blog_title":"\u4e09\u6d41\u541b\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u7f6e\u304d\u5834","provider_name":"Hatena Blog","published":"2021-02-27 08:00:00","url":"https://ken3code.hatenablog.jp/entry/2021/02/27/080000","version":"1.0","type":"rich","description":"Excel VBA CurrentRegion \u3067\u542b\u307e\u308c\u3066\u3044\u308b\u7bc4\u56f2\u304c\u53d6\u5f97\u53ef\u80fd\u3067\u3059 \u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc\u64cd\u4f5c\u306eShift+Ctrl+:(\u30b3\u30ed\u30f3)\u306e\u7bc4\u56f2\u3092VBA\u3067\u53d6\u5f97\u3067\u304d\u307e\u3059Dim objRANGE As Range '\u7bc4\u56f2\u3092\u5165\u308c\u308bRange\u578b Set objRANGE = ActiveCell.CurrentRegion '\u30a2\u30af\u30c6\u30a3\u30d6\u30bb\u30eb\u3092\u542b\u3080\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\u3072\u3068\u304b\u305f\u307e\u308a\u306e\u30bb\u30eb\u7bc4\u56f2\u2026","height":"190","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fken3code.hatenablog.jp%2Fentry%2F2021%2F02%2F27%2F080000\" title=\"Excel VBA CurrentRegion \u3067\u542b\u307e\u308c\u3066\u3044\u308b\u7bc4\u56f2\u304c\u53d6\u5f97\u53ef\u80fd - \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>","title":"Excel VBA CurrentRegion \u3067\u542b\u307e\u308c\u3066\u3044\u308b\u7bc4\u56f2\u304c\u53d6\u5f97\u53ef\u80fd"}