{"image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/d/darucoro9216kun/20250416/20250416142850.png","categories":["\u30d1\u30bd\u30b3\u30f3\u95a2\u9023"],"blog_title":"\u300c\u3060\u308b\u3053\u308d\u300d\uff08\u3060\u3041\uff5e\u308b\u307e\u3055\u3093\u304c\u3053\u3049\uff5e\u308d\u3093\u3060\u266a\uff09","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdarucoro9216kun.hatenablog.com%2Fentry%2F2021%2F05%2F25%2F000100\" title=\"\u30bb\u30eb\u7bc4\u56f2\u306e\u6307\u5b9a\u65b9\u6cd5(VBA) - \u300c\u3060\u308b\u3053\u308d\u300d\uff08\u3060\u3041\uff5e\u308b\u307e\u3055\u3093\u304c\u3053\u3049\uff5e\u308d\u3093\u3060\u266a\uff09\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"\u30bb\u30eb\u7bc4\u56f2\u306e\u6307\u5b9a\u65b9\u6cd5(VBA)","published":"2021-05-25 00:01:00","type":"rich","provider_name":"Hatena Blog","height":"190","version":"1.0","width":"100%","author_url":"https://blog.hatena.ne.jp/darucoro9216kun/","author_name":"darucoro9216kun","url":"https://darucoro9216kun.hatenablog.com/entry/2021/05/25/000100","blog_url":"https://darucoro9216kun.hatenablog.com/","provider_url":"https://hatena.blog","description":"\u300cExcel(VBA)\u300d \u57fa\u672c\u304c\u5927\u5207\u3060\u3068\u601d\u3063\u3066\u307e\u3059\uff01 \u76ee\u7684\u306e\u30bb\u30eb\u3092\u57fa\u672c\u306b\u5247\u3063\u3066\u6307\u5b9a \u4eca\u56de\u3082\u8a2a\u554f\u3057\u3066\u4e0b\u3055\u308a\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3059\u3002 \u4eca\u56de\u306f\u30bb\u30eb\u7bc4\u56f2\u306e\u6307\u5b9a\u3092\u53d6\u308a\u4e0a\u3052\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002 \u3053\u3093\u306a\u8868\u304c\u6709\u3063\u305f\u6642\u306b\u3001\u300cA2\u304b\u3089A10\u307e\u3067\u3092\u6307\u5b9a\u300d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002 Range(\"A2:A10\").Select \u3053\u308c\u3067\u7bc4\u56f2\u6307\u5b9a\u51fa\u6765\u307e\u3059\u3002 \u3067\u3082\u3001\u6700\u7d42\u884c\u306f\u8ffd\u52a0\u3055\u308c\u308b\u306e\u3067\u3001\u4e00\u822c\u7684\u306b\u306f\u4e0b\u306b\u8868\u304c\u8ffd\u52a0\u4f5c\u6210\u3055\u308c\u3066\u3082\u5bfe\u5fdc\u3067\u304d\u308b\u3088\u3046\u306b\u8a18\u8ff0\u3059\u308b\u3053\u3068\u304c\u591a\u3044\u3068\u601d\u3044\u307e\u3059\u3002 \u305d\u306e\u5834\u5408 Range(\"\u8d77\u59cb\u201d,\"\u505c\u6b62\"\uff09 \u304c\u4e00\u822c\u7684\u3067\u3059\u3002 Range(Cells(2, 1), Cells(Rows.Count, 1).End(xlUp)).Selec\u2026"}