{"version":"1.0","width":"100%","description":"\u30d5\u30a3\u30eb\u30bf\u30fc\u62bd\u51fa\u4e2d\u306e\u30c7\u30fc\u30bf\u3092\u30b3\u30d4\u30fc\u3059\u308b\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002Copy\u30e1\u30bd\u30c3\u30c9\u306b\u306f\u300c\u975e\u8868\u793a\u884c\u3092\u30b3\u30d4\u30fc\u3057\u306a\u3044\u300d\u6a5f\u80fd\u304c\u3042\u308b\u305f\u3081\u3001 \u53ef\u8996\u30bb\u30eb\u3092\u53d6\u5f97\u3059\u308b\u5fc5\u8981\u306f\u306a\u304f\u3001\u7d14\u7c8b\u306aCopy\u30e1\u30bd\u30c3\u30c9\u3067\u5b9f\u884c\u53ef\u80fd\u3067\u3059\u3002 \u62bd\u51fa\u4e2d\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u30a8\u30ea\u30a2\u5168\u4f53\u3092\u30b3\u30d4\u30fc\u3059\u308b \u898b\u51fa\u3057\u90e8\u5206\u3092\u9664\u3044\u3066\u30b3\u30d4\u30fc\u3059\u308b \u62bd\u51fa\u4e2d\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u30a8\u30ea\u30a2\u5168\u4f53\u3092\u30b3\u30d4\u30fc\u3059\u308b \u7b2c1\u30b7\u30fc\u30c8\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u30c7\u30fc\u30bf\u5168\u4f53\u3092\u7b2c2\u30b7\u30fc\u30c8\u306eA1\u30bb\u30eb\u3078\u30b3\u30d4\u30fc\u3059\u308b\u5834\u5408\u306f\u3001 \u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002 Worksheets(1).AutoFilter.Range.Copy Worksheets(2).Range(\"A1\") \u5192\u982d\u306e\u901a\u308a\u3001Copy\u30e1\u30bd\u30c3\u30c9\u306b\u306f\u975e\u8868\u793a\u30bb\u30eb\u3092\u30b3\u30d4\u30fc\u3057\u306a\u3044\u6a5f\u80fd\u304c\u3042\u308b\u305f\u3081\u2026","height":"190","provider_url":"https://hatena.blog","author_name":"LimeCode","title":"\u30d5\u30a3\u30eb\u30bf\u30fc\u62bd\u51fa\u4e2d\u306e\u30c7\u30fc\u30bf\u3092\u30b3\u30d4\u30fc\u3059\u308b","published":"2025-11-29 23:54:28","author_url":"https://blog.hatena.ne.jp/LimeCode/","url":"https://www.limecode.jp/entry/utility/copy-filter-visible-data","provider_name":"Hatena Blog","type":"rich","blog_title":"\u548c\u98a8\u30b9\u30d1\u30b2\u30c6\u30a3\u306e\u30ec\u30b7\u30d4","categories":["\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u30bf\u30fc","\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9","VBA"],"blog_url":"https://www.limecode.jp/","image_url":"https://cdn.user.blog.st-hatena.com/default_entry_og_image/154743825/1575205807164226","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.limecode.jp%2Fentry%2Futility%2Fcopy-filter-visible-data\" title=\"\u30d5\u30a3\u30eb\u30bf\u30fc\u62bd\u51fa\u4e2d\u306e\u30c7\u30fc\u30bf\u3092\u30b3\u30d4\u30fc\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>"}